How to remove the corrupted record

J

Joan

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.
 
N

Nikos Yannacopoulos

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

damaged records in .dbf file 0
How do I clear a form? 0
Search Key Not Found error and Transferdatabase command 0
Corrupt File, Help with Possible Solution 4
Error Saving Import/Export Spec 1
Corrupt files due to pivot remnants after saving via VBA 0
Importing FoxPro free table, getting around "the field is too small to accept.." error 1
Email to update records in a table - only want 1 record emailed 1

Top