Import Access Table into Excel
 

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!

Import Access Table into Excel
 

Hi Irishimp23

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Irishimp23" wrote in message ...
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!

Import Access Table into Excel
 

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" wrote:

Hi Irishimp23

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Irishimp23" wrote in message ...
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!

Import Access Table into Excel
 

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",




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Irishimp23" wrote in message ...
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" wrote:

Hi Irishimp23

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Irishimp23" wrote in message ...
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!