Devam Ediyor

Export an Access table to an Excel (Office 365) file using VB6

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)

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

Beceriler: Excel, Microsoft Access, Visual Basic

Daha fazlasını görün: join access table excel, office 365 login using wordpress, export access table xml, export html table excel pdf csv php, export php table excel, import access table excel sheet vba, export data table excel vb net, excel output xml file using vba, editing excel file using vb6, export mysql table excel rapidweaver, possible update access table excel, vbscript connect sql database export values table excel, example export sql table excel, update access table excel file, update access table excel

İşveren Hakkında:
( 5 değerlendirme ) United States

Proje NO: #15456358