Run Time Error 3673 - This table contains cells that are ...

[Moxioron]

Hello.

I have a pretty eas y Module that worked fine until yesterday. Now I am getting the 'Run-Time Error '3673: This table contains cells that are outside the range of cells defined in this spreadsheet'.

However, if I open the Excel file and run the module, it works. is there any way around this so I don't have to open the file?
Function MeridianLinkFileImport()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_MeridianLinkFile", "R:\DEPT-BR\CONSUMER LENDING\AUTO COUNT\Auto Count.xls", True, "Sheet1!A3:BP50000"
End Function

Thanks.

 

[Moxioron]

What is really weird is if I open the file up, save it, and close it, it imports without an issue....

 

[jdraw]

Could be some corruption??? Try compact/repair OR create new database and copy your current objects to the new.

Do you empty the table before importing another set of data?