ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   loading data from access in vba (https://www.excelbanter.com/new-users-excel/98634-loading-data-access-vba.html)

Remy

loading data from access in vba
 
How can I load a database from an Access Application in VBA?
I tried with GetObject function, but I don't know how to get the database.

Remy

Ron de Bruin

loading data from access in vba
 
Hi Remy

Try this
http://www.rondebruin.nl/accessexcel.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Remy" wrote in message ...
How can I load a database from an Access Application in VBA?
I tried with GetObject function, but I don't know how to get the database.

Remy




Remy

loading data from access in vba
 
Great! The code is almost what I was lookinf for (but I'm writting my code
with VBA.net)

The only I have now is to display the informations of the access database in
a form using VBA.net.

Do anyone know how to do that?

Remy


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com