Importing excel data produced corrupted data in Access table

  • Thread starter Thread starter RLee
  • Start date Start date
R

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.
 
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
 
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!
 
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
 
Back
Top