DAO vs. ADO

[bmoremu]

I'm using Excel & Access 97 on NT 4.0. Right now I have users entering data into an excel template which then saves as a .txt file. I'm working on saving the template data to a large database instead of .txt files. I've been reading up on DAO and ADO but am still not clear which I should go with. In addition to inserting/updating entries, I'll also have numerous queries as well. Thanks!

 

[BuGlen]

From my experience, if you plan to use an Access DB for your data, then you should use DAO. DAO is the default Jet data interface, and it's fairly easy to learn.

If you plan to move to another data format later, you should consider ADO so you don't have to make too many coding changes to make the transition.

Hope this helps.

- Glen

Know thy data.

 

[bmoremu]

Thanks, you're right, after a little research it looks like I'll go with DAO since I'm using Excel & Access.

For others with similar questions, I found a good webpage titled "The Evolution of Data-Access Technologies" in MSDN. The title is self-explanatory and it covers technologies from ODBC to ADO.NET. Good read for anyone else interested in a brief comparison of different types of data access.

 

[jcrater]

You should find that with Access, DAO is faster.