| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export Data from many workbooks with many sheets to Access
Hi All
I have some 60 workbooks each containing 8 worksheets. All sheets have the same columns but with varying number of rows. I need to dump this lot into Access To manually import 480 worksheets @ 5 minutes per sheet is 40 hours. Any sugesstions as to the best approach? TIA johnb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I Export data from to Access to an Excel Template | Excel Discussion (Misc queries) | |||
| Export memo field in Access to Excel - data gets cut off | Excel Discussion (Misc queries) | |||
| How do I Export range of row/column data to Access | Excel Discussion (Misc queries) | |||
| data import and export in to access | Excel Discussion (Misc queries) | |||
| Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) | |||
Threaded Mode
