Code suggestion for opening Excel using ADO vs DAO

[Rx_]

Does anyone have any code or code sites to suggest for this?
It sounds interesing, would like to run some test and see if there is any real difference between ADO and DAO.

For opening up a series of Excel Workbooks to extract data from a range - to bring back to Access, was recently advised:

I'd run it against accessing the workbook via ADO - With ADO you don't need a reference to Excel and you don't need to create an instance

 

[boblarson]

I'd run it against accessing the workbook via ADO - With ADO you don't need a reference to Excel and you don't need to create an instance

Not sure about all of that but it is always cool to learn new things. But the part about not needing an instance is kind of pointless as you don't need to set a reference.

But I would be interested to find out exactly what that means.

 

[Rx_]

I would be interested in anyone's experience or suggestion.
This is my quick assessment: Sticking with tried and true Access VBA referencing Excel.Application

http://support.microsoft.com/kb/257819
It is a little buggy
Complicated
Limited
Almost looks as if a whole sheet has to be returned (put how many rows in the scan) and then do the work locally.

No clue as to the efficiency once a connection is made.

 

[boblarson]

I would be interested in anyone's experience or suggestion.
This is my quick assessment: Sticking with tried and true Access VBA referencing Excel.Application

http://support.microsoft.com/kb/257819
It is a little buggy
Complicated
Limited
Almost looks as if a whole sheet has to be returned (put how many rows in the scan) and then do the work locally.

No clue as to the efficiency once a connection is made.

Definitely looks more complicated and quite a few limiting factors. I'll just use COM to deal with it.