Transferspreadsheet question

[AnnePep]

Hi,
I am working on a program that will import a spreadsheet of billing information that is emailed to us monthly.

I have code so that the user just clicks "Import Billing data" and they are prompted for the path and filename. I then use the Transferspreadsheet method to place the data in a new table.

Here is my problem - everytime the table is created with 64000 rows! Most of them are blank. I assume this is because the limit of excel spreadsheet is 64K or so rows.

Anyone have a way to only import rows with data? I didnt want to ask the user to alter the spreadsheet and set a named range.

Here is the test code I used:
DoCmd.TransferSpreadsheet acImport, , "PrePassPlus", "C:\test.xls", True, "ez-apr!"

Thanks so much for any help!!

Anne

 

[mark curtis]

Not looked at the TransferSpreadsheet method but you could tag a delete query onto the import routine where you delete all rows with no data?