Connecting to Access Database from Excel

F

Feifei

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
 
T

Tom Ogilvy

In Excel,
have you created a reference in the VBE in tools => Referneces to the ADODB
reference library?
 
F

Feifei

I actually just found that out right after I post the question. Knew it
would have been a really quick fix. Thanks!
 

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

Similar Threads

export excel data to access table using ADO 0
Tough one - Timeout doesn't work 0
Access to Excel format 2
Why does variant not need set? 3
Import multiple Access Queries 0
interaction with excel and ms SQL (retrieval of records from sql intoa sheet) 2
ADO - Access to Excel 5
Adding hyperlink to access database from excel 1

Top