Open Access Database From Excel

Is there a way with VBA that I can simply open an access database?

yes, various different ways. I doubt you actually want to open the database though, just pull / push data to it?

I'm a big fan of using SQL to access an Access Db, if you'll pardon the pun.

Yes I use SQL to query also. But all I want is to open an access database. Within the access database I have a AutoExc macro that will run as soon as the file is open and i want that to run after I have exported some file using excel , so I need a piece of code to open access at the bottom of my code.

Example

Please Login or Register  to view this content.