The following syntax is failing when run as Open Event Procedure within an Access form.
I suspect it might be the "8" spreadsheet type and our Access 2002 being dated compared to the Excel 2010 software used to create the xlsx file.
But I'm hoping it's something else.
The tblCOIvendors is a simple design of just two fields: Vendor (text=255) and ExpDate (as Date).
I get the "Run-time error 3274, External table is not in the expected format."
Rem Copy scanfield's "2013 Certificates of Insurance from Vendors.xlsx" to COIvendors.htm
DoCmd.TransferSpreadsheet acImport, 8, _
"tblCOIvendors", "\\bordensrv\users\scanfield\2013 Certificates of Insurance from Vendors.xlsx", _
DoCmd.OutputTo acOutputQuery, "qryCOIvendors", acFormatHTML, "\\bordensrv\intranet\reports\COIvendors.htm", True