importing from Excel

[steelman]

I am trying to import a table to a new table in Access. I get the finish
butotn in the wizard, and get an error. All it says is "An error occurred
when trying to import file ....The file was not Imported."

I checked the cell type in my Excel spreadsheet. I eliminated all odd empty
boxes. I scratched my head...

Let me know what you think/

 

[pietlinden]

I am trying to import a table to a new table in Access.  I get the finish
butotn in the wizard, and get an error.  All it says is "An error occurred
when trying to import file ....The file was not Imported."

I checked the cell type in my Excel spreadsheet.  I eliminated all odd empty
boxes.  I scratched my head...

Let me know what you think/

What if you create the table you intend to put the records into first
and then try the import? Then you can create an import specification
to map the Excel columns to the correct fields in your table.