I have a VB6 app to enter/edit/process data to an Access 2000 database. One of the functions of the program is to export the values in a temporary table (created by the VB6 app) to an Excel file (Office 365). I recently upgraded from Office 2013 to Office 365. Here is the one line of code that worked for Excel 2013.
[url removed, login to view] "SELECT * INTO [Excel 8.0;DATABASE=" & strFullPath & ".xls]." & strSheet & " FROM " & strTable
When I run the line of code above with Office 365 I get the following error:
Run-time error "3275" Unexpected error from external database driver (1).
My project is to:
(1) Debug the program code so it will work with Excel (Office 365)
(2) Create new VB6 code that I can put in my program code to create an Excel file from the values in the temporary Access table