If you were to export your worksheets as CSV files into Access you would
save the effort of combining all your files just to export the data. Just
an idea that may work!

Regards.

Bill Ridgeway
Computer Solutions

"Mike" wrote in message
...
I have 225 Excel files, each with one worksheet, all with exactly the same
colums and headings. Is there a way to combine all 225 worksheets into one
long single worksheet? I need this to export to an Access table.

I also have a workbook with 35 worksheets that should be combined into one
worksheet, for the same reason.

thanks,
Mike