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