Import Access Table into Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Do I use the big macro? And does it matter if my excel spreadsheet and my
access database have two different paths?
 
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.
Click to expand...

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?
Click to expand...

No problem

In my examples I use

ThisWorkbook.Path & "/OrderDatabase.mdb"

But you can change that to

"C:/Data/OrderDatabase.mdb",
 
Back
Top