Hello.
I have a pretty simple code to import a spreadsheet. However, I am getting a Run-Time error '3011 The Microsoft Access database engine could not find the object 'Redemption Details$A6:A50000'.
I am running another module with the same path, so I know it is not a rights issue. I have checked to make sure the tab was spelled correctly and nothing seems afoot. Where am I going wrong? Thanks.
Option Compare Database
Dim myCheck
Function PointRedemptionImport()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_TW Point Redemption Report", "R:\DEPT-BR\CONSUMER LENDING\VISA\BreakAway Loyalty\Point Summary by Cardholder\Point Summary By Cardholder.xls", True, "Redemption Details!A6:AI50000"
End Function
I have a pretty simple code to import a spreadsheet. However, I am getting a Run-Time error '3011 The Microsoft Access database engine could not find the object 'Redemption Details$A6:A50000'.
I am running another module with the same path, so I know it is not a rights issue. I have checked to make sure the tab was spelled correctly and nothing seems afoot. Where am I going wrong? Thanks.
Option Compare Database
Dim myCheck
Function PointRedemptionImport()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_TW Point Redemption Report", "R:\DEPT-BR\CONSUMER LENDING\VISA\BreakAway Loyalty\Point Summary by Cardholder\Point Summary By Cardholder.xls", True, "Redemption Details!A6:AI50000"
End Function
