Paradox import - not extracting last 800 records

[1421]

Hi All

I am importing (and in some cases appending) data from Paradox (DOS - i think version 4.5),. Among the databases that I am importing there is one with 89 meg bytes, and it does without any problems. I am trying to import a DB, which is 1.6 meg & the last approx 800 records are not being imported (i persume that its the 'last' 800, it may be 800 records from the file in middle etc.). The table structure has about 780 fields. I am using VFP Ver 9. Please help!

Thank You

 

[1421]

CORRECTION! I'm sorry i might a small error, it's 781 bytes per record with 57 fields.

 

[baltman]

Did you try opening with Excel oe Access to see if either of them can access all the data or not? If it can, the easiest thing might be to save it as an Excel or CSV and import from it.

Brian

 

[1421]

thanx for the answer, i spoke to the Paradox programmer & he said that the Paradox table may be corrupted & therefore this problem has occurred!