Open Ms Access database with excel macro
 

How can I open exiting access database with excel macro...
I want to import data from excel to access database and I can do that with mackro when this database is open...?
If you have macro code to do this, please show that to me.:)

Open Ms Access database with excel macro
 

http://www.erlandsendata.no/english/...odao/index.htm
The first two examples export to Access.

HTH,
Merjet

VS: Open Ms Access database with excel macro
 

Thank you, this help me a lot...:

----- merjet kirjoitti: ----

http://www.erlandsendata.no/english/vba/adodao/index.ht
The first two examples export to Access

HTH
Merje