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?

Earlier versions of Excel only supported 16,000+ rows. Make sure your transferSpreadsheet Action/Method is set for Excel 97.

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.