Connecting to a DB in VBA

T

Tom S

I'm trying to connect to an ODBC-compatible database thru VBA, but I can't
seem to get it to work. I've looked at the help files, and some of the
things it tells me to do, aren't recognized when I try to run them.
Example:
Dim wrkODBC as WorkSpace
It doesn't recognize the "user-defined type". I'm wondering if I'm missing
some AddIn or something. I've installed everything that came with the disk,
as well as made sure that they were selected in the options portion of
Excel, but nothing is dealing with ODBC connections.
Can somebody please tell me what I'm doing wrong and how to fix this?
Thanks!!!

XP Home
Excel 2002
ASA 8 DB (thru ODBC connection)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top