importing from Excel 2003 to Access 2003

[PAG]

Hi,

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

 

[Peter Hibbs]

If this is a 'one off' operation try using the Excel to Access
Converter Utility program at :-

http://www.rogersaccesslibrary.com/...me='Excel to Access Converter Utility program'

HTH

Peter Hibbs.