How to remove the corrupted record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem to export Access data to SAS. I only can export some part of
the data. For example, I have 230 records. I only can export the first 35
record. The 36th records only include the id but no data. I suspect the 36th
record was corrupted. When I get in the Access database, I copied the table
to a new table, then I tried to delete this corrupted record. However, I can
not delete it. If I tried to delete other non-corrupted records, I can delete
them. What I need to do is to remove this corrupted record, thus I can export
the whole data to SAS. Please help.
 
Joan,

Have you run a Compact and Repair on your database? If that doesn't fix it,
try importing the table in another database.

HTH,
Nikos
 
Back
Top