I am trying to use the following to import an excel datasheet into MS access table.
DoCmd.TransferSpreadsheet acImport, 3, _
"Report", "C:\Rep\Report.xls", True, "A1:L3000"
and I am getting
Runtime error 3274
External table is not in the expected format.