importing from Excel 2003 to Access 2003

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exporting from Excel 2
Manipulating Excel from Access 9
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import Excel Workbook from Sharepoint 4
Error Message - Importing Excel to Access 2003 2
importing multiple worksheets from excel to access 1
Importing XML Data in Access 2003 1
Problems Importing from Excel to Access 3

Top