Code suggestion for opening Excel using ADO vs DAO (1 Viewer)

Rx_

Nothing In Moderation
Local time
Today, 02:14
Joined
Oct 22, 2009
Messages
2,803
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

Smeghead
Local time
Today, 01:14
Joined
Jan 12, 2001
Messages
32,059
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_

Nothing In Moderation
Local time
Today, 02:14
Joined
Oct 22, 2009
Messages
2,803
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

Smeghead
Local time
Today, 01:14
Joined
Jan 12, 2001
Messages
32,059
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.
 

Users who are viewing this thread

Top Bottom