Export Data from many workbooks with many sheets to Access

[johnb]

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

 

[Ron de Bruin]

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

 

[johnb]

Cheers Ron Got the job sorted.

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