Re: Importing excel data produced corrupted data in Access table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

"RLee" <rlee@xxxxxxxxxxxxx> wrote in message
news:1142722450.110560.214500@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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 *** and append the
table with the new ***. But how do I get rid of the bogus data in
the exisiting table?

Thanks for your help!



.

Quantcast