| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creation of Import Files
I'm trying to take data from 74 Excel files, 8 worksheets and import it into
an Access database. I'm fairly fluent in Access, and I can accomplish this, but the import process is extremely slow (5 hours) due to the fact all the Excel files are linked. If I use Copy/Paste Special/Values, the links are broken and the import time drops to about an hour, which is acceptable. I'm looking for an automated means in Excel to loop through all 74 files, 8 worksheets per file, and apply a Copy/Paste Special/Values command within each worksheet. Help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Creation in Excel / MS Query -- .cub files | Excel Discussion (Misc queries) | |||
| Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
| Disable creation of Enhanced Meta Files? | Excel Programming | |||
| How can I selectively stop creation of Excel *.xlk files? | Setting up and Configuration of Excel | |||
| Import multiple files macro can't find files | Excel Programming | |||
Threaded Mode
