Find Jobs
Hire Freelancers

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

$30-100 USD

Cancelled
Posted over 6 years ago

$30-100 USD

Paid on delivery
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
Project ID: 15456358

About the project

15 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Belmond, United States
5.0
6
Payment method verified
Member since Jun 2, 2009

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.