Transferspreadsheet method only imports first 2 rows

[socasteel21 via AccessMonster.com]

I am using the transferspreadsheet method to import 3 worksheets within one
workbook from Excel. I have a 4 tabbed workbook in Excel. The first tab is
a form that is only used for data entry. The other 3 tabs contain tables
that mirror my tables in Access. (tblClaim, tblPartPerClaim, and
tblJobCodesPerClaim)

I have created a button on my "frmClaim" that calls the windows dialog box to
browse for the file. After the user selects a file, code with in the OnClick
() event of the button imports each tab to a table (Import: tblClaim, Import:
tblPartPerClaim, and Import: tblJobCodesPerClaim). Then 3 append queries
run to append these records to the permenant tables.

The problem is that Access will only import the first 2 rows of each
worksheet. I can go to the database window and manually import each
worksheet (File-Get External Data-Import Table), and it works fine, but for
some reason the transferspreadsheet method will only import the first 2 rows.

I would greatly appreciate some help. I have sent this Excel file to several
people who are using it, and I have to be able to import the data that they
are sending me.