Importing excel data produced corrupted data in Access table

[RLee]

After importing an Excel spreadsheet into Access, the data for 2
records out of 9500 records was not readable. Symbols (square boxes)
appeared in all the imported fields for 1 of these records, and the
other record had field names and other miscellaneous text filling in
the fields. I've tried to delete and edit these 2 records, but the data
cannot be edited. Could you please provide some methods to edit these
records? Thank you.

 

[Jeff Boyce]

You've "tried to delete ... these 2 records"? What happened when you tried?

Have you gone back to the source and deleted/edited the rows in the
underlying spreadsheet?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[RLee]

The data remained in the records and could be not manipulated in any
manner. Typing into the cell itself, highlighting the row, trying to
delete the entire row, etc. did not result in any changes to the
corrupted data. The table could not save or be changed to the
"correct" data after I tried to enter the data to replace the square
boxes.

I tried to edit and delete using all of the menu choices and the
keyboard key strokes to cut, delete, or backspace over the data.

I will try to retype the Excel data into a fresh sheet and append the
table with the new sheet. But how do I get rid of the bogus data in
the exisiting table?

Thanks for your help!

 

[Jeff Boyce]

What happens if you make a copy of the table (structure only), and append to
that copy instead of the original table?

Regards

Jeff Boyce
Microsoft Office/Access MVP