Problem with Importing Excel File

[bossynix]

Hi I wonder if someone could help - I've tried to find the cause of my problem with no success?

I have a macro set up to import an Excel Spreadsheet - infact I have several macro's set up to import several spreadsheets. However my users are only reporting a problem with one - The table imports fine, however there are about fifteen blank records at the begining of the table - all data is complete and I have to go in each day and delete these blank records! I don't know why it's doing it - I have checked all my data types against the spreadsheet and they are fine. Checked the data in the spreadsheet - no blank rows!
This never used to be a problem and I just don't know what it is! I can live with deleting the records but I would like to get it sorted if possible!

Thanks

 

[FLabrecque]

1. Check the number of rows in EXCEL and your imported TABLE. It may be blank due to key violation. If the number of rows are the same, go to step 2.

2. Add a step in the macro after the import: runSQL. This will delete the unwanted rows instead of you.