corrupt table...can see some data

[pheonix1t]

Hello,
I've got a corrupt table...if you do a Microsoft Query from Excel, you
can see the top of the table. But if you scroll down, it crashes. I've
noticed some rows are missing on the lower parts of the table. I think
this is the cause.
I can import the table without the data successfully. But if I try to
get the data it crashes.
Any ideas on how to get what good data there is? I tried exporting the
data as text from the other tables and I was successful. But this
corrupt one won't even let me do that.

Thanks,

Oskar

 

[Arvin Meyer]

On a COPY of the file, you can try doing a Jetcomp repair:

http://support.microsoft.com/default.aspx?scid=kb;en-us;295334

If that doesn't work, if you have a sequential autonumber, it is sometimes
possible to extract only the good records. Try running a query that gets the
first half of your records into a new table. Then run a few more at a time
until you find the records which break and then select around them.

Peter Miller at PKSolutions has an excellent record of saving corrupted
databases at a nominal cost:

http://www.pksolutions.com

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access