I have an Access Macro with the transferspreadsheet command to a special named workbook in an Excel Spreadsheet. The name of the workbook is the same name as the Access table being transferred. It just now began throwing throwing an "Unexpected error from External Database driver (1)". ANY ideas why it no longer runs?? I did install office 365 recently, but this is still running on Office 2002. I also put the database into 365 and tried the same Macro there, and it APPEARS to run fine in 365. No other changes have been made in many months (at all ) to either the 2002 database nor to the .xls spreadsheet.
Last edited: