Knowledgebase
[QXL-ALL] How to export to MS Access
Posted by Jack - QODBC Support on 24 April 2017 11:10 AM

How to export to MS Access

Problem Description:

I am using QXL & I want to export QuickBooks Data to MS Access.

How can I export QuickBooks Data to MS Access using QXL?

Solution:

You can export QuickBooks Data to MS Access using QXL.

First, You need to create an MS Access database file (.accdb) and save it to your disk drive.

Create a new ODBC DSN for MS Access which will point to the MS Access Database.

Search for ODBC or Navigate to C:\Windows\SysWOW64\ folder and find odbcad32.exe and double click on odbcad32.exe

Switch to System DSN

Select Microsoft Access Driver (*.mdb, *.accdb)

 

Input the Data Source Name and click "Select."

Navigate to the folder containing your MS Access database file.

I have already created ODBC DSN for MS Access below the property of the DSN. We will use this DSN in QXL.

The first step in adding an ODBC connection is to click on the settings icon for QXL options details.

Navigate to "Pro Edition" & click the "Add New" button to add the New Connection.

 

Enter connection details (i.e., Connection Name, Connection String), select "ODBC Data Source" as a Connection Type & "Microsoft Access" as a Mapping Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample ODBC Connection String Format: DSN = Data Source Name

For Example DSN=QXLMSA

Test Connection Successful.

Click the "Save" button to save connection details.

Connection information updated.

The connection is added to the dropdown list.

Navigate to the "General" tab & select "SQL Server / ODBC Data Source (QXL Pro Edition)" as a Format & click "Close."

Now data is ready to export into MS Access. You can export by clicking on the Export icon from QXL Setup Screen.

QuickBooks Data is exported to MS Access.

 

(0 vote(s))
Helpful
Not helpful

Comments (2)
Ranier Soliman
27 March 2018 08:19 AM
Is the data going to be sync automatically with access table?
Jack
28 March 2018 07:41 AM
Hi Ranier,

QXL is storing exported data in MS Access as Local table not Linked table. So if you want to get updated data, then you need to export table again.
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).