| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Connecting to Access Database from Excel
Hi - I'm tring to open an Access 2003 database from Excel 2003 and append a
range of Excel cell values into an existing table. When I try to declare the connection variable, I got a compiler error for "user-defined type not define" for Dim Conn As New ADODB.Connection Is there anything else I need to do before declaring the connection variable? Thanks! Feifei |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Connecting to Access Database from Excel
In Excel,
have you created a reference in the VBE in tools = Referneces to the ADODB reference library? -- Regards, Tom Ogilvy "Feifei" wrote: Hi - I'm tring to open an Access 2003 database from Excel 2003 and append a range of Excel cell values into an existing table. When I try to declare the connection variable, I got a compiler error for "user-defined type not define" for Dim Conn As New ADODB.Connection Is there anything else I need to do before declaring the connection variable? Thanks! Feifei |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Connecting to Access Database from Excel
I actually just found that out right after I post the question. Knew it
would have been a really quick fix. Thanks! "Tom Ogilvy" wrote: In Excel, have you created a reference in the VBE in tools = Referneces to the ADODB reference library? -- Regards, Tom Ogilvy "Feifei" wrote: Hi - I'm tring to open an Access 2003 database from Excel 2003 and append a range of Excel cell values into an existing table. When I try to declare the connection variable, I got a compiler error for "user-defined type not define" for Dim Conn As New ADODB.Connection Is there anything else I need to do before declaring the connection variable? Thanks! Feifei |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| connecting to sql database from excel using file dsn | Excel Programming | |||
| connecting database curopting excel | Excel Programming | |||
| Connecting Excel, Access and SQL Server | Excel Programming | |||
| Connecting To a Excel Database | Excel Programming | |||
| Excel Connecting to SQL Server Database - Need your Help | Excel Programming | |||
Linear Mode
