External table is not the expected format.... Access transferspreadsheet function
Posted on 2011-09-29
I'm using the Transferspreadsheet function to import an Excel file using the following code. I've checked the values in the variables with msgbox but get the "External table is not in the expected format" error. The file is in the location....
DoCmd.TransferSpreadsheet acImport, , "Clarity_Project_Information", varClarityFilePath & varClarityFileName, True
Thanks for your help,