Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADODB connection vs. ODBC

Status
Not open for further replies.
almoes

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.
 
Sort by date Sort by votes
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
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
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
Asp database connection for login fails
Replies
11
Views
69
guitarzan
guitarzan
BunBo900
  • Locked
  • Question
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Replies
1
Views
88
BunBo900
BunBo900
EricBCA
  • Locked
  • Question
Is it possible for ASP to connect to SQL Server via ODBC without a password
Replies
1
Views
46
ChrisHirst
ChrisHirst
dwg23
  • Locked
  • Question
ADODB.Recordset error '800a0cc1' Item cannot be found in the collection corresponding to the reques
Replies
3
Views
91
gmmastros
gmmastros
ahoodin7
  • Locked
  • Question
<object> and Windows 7+ vs Windows XP
Replies
3
Views
55
guitarzan
guitarzan

Part and Inventory Search

Sponsor

Back
Top