Search results

Hello, When I posted my original line of code I made a mistake as many people noted I neglected to include the path to the spreadsheet. Here is the correct line of code. Do.Cmd.TransferSpreadsheet acImport acSpreadsheetTypeExcel12, "tbl_DocumentDetail_temp, sFile, True , RangeName sFile is...

Hello, When I posted my original line of code I made a mistake as many people noted I neglected to include the path to the spreadsheet. Here is the correct line of code. Do.Cmd.TransferSpreadsheet acImport acSpreadsheetTypeExcel12, "tbl_DocumentDetail_temp, sFile, True , RangeName sFile is...

Hi Jiri, I tried naming the sheet LNGSheet and I get the same error. The error message just says can't find LNGSheet$A14:R583 Any other ideas? Thanks in advance for any suggestions.

I am developing an access application which is used to print out transmittal cover sheets and individual transmittal forms. The data is kept on excel sheets. I am attempting to bring data into an access table using the docmd.transferSpreadsheet command. I make a copy of the sheet and I do some...