| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file will not import to Access, what may be the cause | Excel Discussion (Misc queries) | |||
| access query to import to excel | Excel Worksheet Functions | |||
| Excel & Access Import Problems | Excel Discussion (Misc queries) | |||
| Import Access into Excel | Excel Discussion (Misc queries) | |||
| Import from Access to Excel, via pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
