Using ODBC Connection in Excel VBA

[jonsan]

I need to open an ODBC connection to a database. I have the connection string (I used the record macro feature to find it), but I don't know what object or syntax to use. I have an update query written in SQL that I need to execute on the databse from the macro. Can anyone give me a code example or let me know what object to use?

Thanks!

J

 

[PHV]

Search your local drives for files named dao*.chm;ado*.chm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jonsan]

I did not find any files with those names. I know how to use a ADODB object to create and open a connection to an Access database, I am just not sure what object to use to connect to a different type of database. Like I said, I have the connection string (which specifies ODBC), and the SQL statement already written.

Thanks!

J

 

[Johnny42]

try this :

http://www.able-consulting.com/ADO_Conn.htm