Hello friends
when trying to import a sheet from an excel file I face this problem
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TempDetails", txtFolderPath.Value & "\" & cboFileName.Value, False, cboSheets.Value & "$"
Sample of Sheet name Include dot
2.4_OTLDetails
This is not a valid name. Make sure it is a valid parameter or alias name, that it does not include invalid characters or punctuation, and that the name is not too long. (Error 3125) | Microsoft Docs
What should I do
when trying to import a sheet from an excel file I face this problem
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TempDetails", txtFolderPath.Value & "\" & cboFileName.Value, False, cboSheets.Value & "$"
Sample of Sheet name Include dot
2.4_OTLDetails
This is not a valid name. Make sure it is a valid parameter or alias name, that it does not include invalid characters or punctuation, and that the name is not too long. (Error 3125) | Microsoft Docs
What should I do
Last edited: