| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export Data from many workbooks with many sheets to Access
Hi johnb
Try this to create a new file with the data You can import it in Access http://www.rondebruin.nl/merge.htm Or see http://msdn.microsoft.com/en-us/library/cc837974.aspx -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "johnb" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Export Data from many workbooks with many sheets to Access
Cheers Ron Got the job sorted.
"Ron de Bruin" wrote: Hi johnb Try this to create a new file with the data You can import it in Access http://www.rondebruin.nl/merge.htm Or see http://msdn.microsoft.com/en-us/library/cc837974.aspx -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "johnb" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
