Import Access Table into Excel

[Guest]

I have to import information stored in an access table into excel every month
in order to update the excel spreadsheet. I would like to automate it with a
macro but I need a code for it? How do I do it?

Thanks!

 

[Ron de Bruin]

Hi Irishimp23

Maybe this page will help
http://www.rondebruin.nl/accessexcel.htm

 

[Guest]

Do I use the big macro? And does it matter if my excel spreadsheet and my
access database have two different paths?

 

[Ron de Bruin]

Read the info on the page

We use small macro's that are not so difficult to use/change that call one big macro named GetDataFromAccess.

Try the test files first, you only change and run the small macros

And does it matter if my excel spreadsheet and my
access database have two different paths?

No problem

In my examples I use

ThisWorkbook.Path & "/OrderDatabase.mdb"

But you can change that to

"C:/Data/OrderDatabase.mdb",