Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to a DB in VBA
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to a DB in VBA
See reply to my Q on "ACT!" 14/1/04, may help.
AB "Tom S" wrote in message ... 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Connecting formulas | Excel Worksheet Functions | |||
connecting to MYSQL | New Users to Excel | |||
Connecting ballons | Excel Discussion (Misc queries) | |||
Connecting Worksheets | Excel Discussion (Misc queries) | |||
connecting to databases | Excel Discussion (Misc queries) |