Getting data form access database running excel macro

[edita]

Hi
I'm writing macro in Excel and I need to get data from database which is in Access.
As I know I need to add some libraries in Tool/References and I added:
Microsoft Access 10.0 Object Library
Microsoft DAO 3.6 Object Library
Microsoft ADO ...

How can I declare variable as ADODB.Connection, for example?
Have you got any examples of procedures that could help me?

Thanks in advance,
bye

 

[AndyWatt]

DAO and ADO are "competing" database technologies. There is no point attempting to use both. I would suggest using ADO over DAO as it is a newer and faster technology.

Also this is a Visual Basic forum not a Visual Basic for Applications forum (which is the language you are using when coding in Excel). They are not the same.

To declare a object variable as ADODB.Connection:

Dim conX As ADODB.Connection

Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"Why does my program keep showing error messages every time something goes wrong?"

 

[edita]

I tried

Dim conX As ADODB.Connection

but it return error: User-defined type not defined.

By the way, do you know any Visual Basic for Application forum?

Thanks,
Bye

 

[AndyWatt]

Okay, in Tools \ References put a check next to "Microsoft ActiveX Data Objects 2.x Library" (ADO has versions 2.0 through to 2.8) then try again.

forum707 is the VBA forum.

Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"Why does my program keep showing error messages every time something goes wrong?"