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)


(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: visual basic export to excel, docmd.outputto xlsx, write to excel file, docmd.outputto excel, visual basic write to excel, vb6 to excel, ms access vba export query to excel, access vba transferspreadsheet, 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

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

Proje NO: #15456358