I am trying to import / link a excel spreadsheet which contains approx. 37000 records. After I do this I can only view approx, 16000 of these. I even tried deleting the spreadsheet down to approx. 27000 records and get the same result???
Any thoughts on what maybe causing this?
I am using Access 97
Do you have the same problem when you link? The spreadsheet may be so large that when you import it, it makes your database exceed the 1 gig limit, which is the limit for A97. (A2003 goes to 2 gigs; I don't know about A2000.) If that's the case you shouldn't have that problem when you link. If you do, maybe there's a different problem.
Try the following: delete the spreadsheet from your Access DB and compact your database (Tools--> Database Utilities--> Compact and Repair Database). Now try re-importing. Do you still have the problem?
I would look at the 16001st record. Is there any weird data in that record? What happens if you make a copy of the spreadsheet, delete that row and try to re-import?
Another thought, copy the spreadsheet, save it as a CSV file (File/Save As), then change the extension to TXT and open it in Notepad or Wordpad. Any data corruption/weirdness might be easier to spot this way. Also turn off word wrap in Notepad.