How to export to SQL Server - using SQL Default Driver

Problem Description:

I am using QXL & I want to export QuickBooks Data to SQL Server.

How can I export QuickBooks Data to SQL Server using QXL?

Solution:

You can export QuickBooks Data to SQL Server using QXL. There are two ways to export QuickBooks Data to SQL Server.

1. Using SQL Server default driver.
2. Using SQL Server ODBC Driver

Using the SQL Server default driver

The first step in adding an SQL Server 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 "SQL Server Driver" as a Connection Type, and click the "Test Connection" button.

You can insert any value for the Connection Name.

Sample SQL Server Connection String Format: Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

For Example: Server=WIN-O8RQBVCMJFC;Database=Desktop;User Id=sa;Password=sa;

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 the data is ready to export into SQL Server. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to the SQL Server.

Using SQL Server ODBC Driver

First, you need to create an ODBC DSN for SQL Server, which will point to your Database.

I have already created an ODBC DSN for SQL Server below the properties of the DSN.

SQL Server ODBC DSN test connection successful. 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 SQL Server" 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=QXLSQL

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 the data is ready to export into SQL Server. You can export by clicking on the Export icon from the QXL Setup Screen.

QuickBooks Data is exported to the SQL Server.