Hi,

Does anyone have any ideas/tools for cleaning up the excel
workbooks to be able to import into Microsoft Access.

I am trying to import from some workbooks that are Excel 2003 to a new table
in Access 2003. The excel files have column headings and a lot of data. I
receive an error message trying to use the transferspreadsheet macro - all
the error says is action failed. Any idea how I can clean up the excel
workbook to be able to import into access. I am not sure how or where the
Excel workbook was created.

Thanks

Peter