View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JohnB JohnB is offline
external usenet poster
 
Posts: 53
Default 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