Export an Access table to an Excel (Office 365) file using VB6
$30-100 USD
Kansellert
Lagt ut over 6 år siden
$30-100 USD
Betalt ved levering
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.
[login to view URL] "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)
OR
(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