How to remove the corrupted record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joan - 03 Nov 2004 23:25 GMT

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.

Reply to this Message

Nikos Yannacopoulos - 04 Nov 2004 09:15 GMT

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

> 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
[quoted text clipped - 4 lines]
> them. What I need to do is to remove this corrupted record, thus I can export
> the whole data to SAS. Please help.

Reply to this Message