Mar 13, 2003 #1 almoes Programmer Jan 8, 2003 291 0 0 US I want to make SQL queries to an excel file. What is the appropriate object to use, ADODB or ODBC connection? Which are the diferences? Thanks.
I want to make SQL queries to an excel file. What is the appropriate object to use, ADODB or ODBC connection? Which are the diferences? Thanks.
Mar 13, 2003 #2 contactop Programmer Mar 5, 2003 13 0 0 IN use ADODB connections, as Excel is also from Microsoft, which will allow u to use the ADO obkject model in Excel aslo. Upvote 0 Downvote
use ADODB connections, as Excel is also from Microsoft, which will allow u to use the ADO obkject model in Excel aslo.
Mar 13, 2003 Thread starter #3 almoes Programmer Jan 8, 2003 291 0 0 US ok, and which is the proper provider for excel? Is Microsoft.Jet.OLEDB.4.0 ok? I have troubles using this one. Upvote 0 Downvote
ok, and which is the proper provider for excel? Is Microsoft.Jet.OLEDB.4.0 ok? I have troubles using this one.
Mar 13, 2003 #4 JamesLean Programmer Dec 13, 2002 3,059 0 0 GB Some useful info for you: http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForExcel --James Upvote 0 Downvote
Some useful info for you: http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForExcel --James
Mar 13, 2003 Thread starter #5 almoes Programmer Jan 8, 2003 291 0 0 US cool!!! thanks a lot!! Upvote 0 Downvote