Check Excel File For Data

[rookery]

Does anyone know if it's possible to check an Excel file before import i.e using TransferSpreadSheet method, to assess if it contains any data?

I dont want my users importing blank Excel spreadsheets into the database.

 

[sdimov]

You have to open Excel and check each sheet or at least one if it contains data - if it does you proceed with the TransferSpreadsheet, otherwise you stop.

 

[rookery]

Thanks but how do you check to see if the sheet contains data? Check each row individually? This sounds very long-winded.

 

[Bullsandbears123]

I do not think there is another way. But you can limit the range so you do not check thousands if you know the data will be say in the first 500 columns and rows. It does not take long to run. I have done it, and it runs rather quickly.

 

[rookery]

I thought this would be the case. It seems a rather crude method. I think what I might end up doing is importing the file into a table and then checking how many records are in the table using:

CurrentDb.Tabledefs("tblName&quot.RecordCount

Thanks for your input.