When I import an Excel Spreadsheet of 46,000 lines, the import is always truncated to 16,000 lines. I have a sample database where someone else was able to import all 46,000 ... any ideas on settings, etc?
Thanks. I did get Excel to read the 43,000 records, the problem was importing them into Access 97. Turns out that Access had no problem if it was a *.csv file, but did not like the *.xls format. Someone mentioned that is a bug in Access 97. Thanks again for your attention.