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.

 

[Chris O'C via AccessMonster.com]

If you convert the spreadsheet to csv format, you can import the data with
the import text wizard. It will create an errors table that tells you what
didn't import correctly by row and column name.

Chris
Microsoft MVP