[QODBC-Desktop] How to use DTS to Import QuickBooks Data into MS SQL Server
Posted by Juliet (QODBC Support) on 11 November 2009 08:24 AM

System Environment

     Windows XP System

     QuickBooks Enterprise Solution 9.0 (USA)

     QODBC v10

     Microsoft SQL Server 2000


Configuration of QODBC

     When using QODBC with MS SQL Server, the Use DCOM Server option should be checked in QODBC Setup Screen (Server Edition Tab).

     If you want to set up a remote connection using RDS Server/Client, please see: Accessing QuickBooks data remotely via QODBC v9 and above using RDS for more.

     Note: Using RDS to import QuickBooks data into MS SQL Server remotely is almost the same as on the local machine. The little difference will be listed below.


Import QuickBooks Data into MS SQL Server via DTS

Create a New Database in MS SQL Server

1. Run Service Manager of MS SQL Server.

    Start -> Program -> Microsoft SQL Server -> Service Manager

2. Run Enterprise Manager of MS SQL Server.

    Start -> Program -> Microsoft SQL Server -> Enterprise Manager

3. Create a new database in SQL Server Enterprise Manager and name it test1.

Import Data using DTS

1. Right click test1 -> All Tasks -> Import Data.

2. Setup using DTS Import/Export Wizard

     The DTS Import/Export Wizard dialog box pops out. Click Next to go on.

Data Source Setup

     Select QODBC Driver for QuickBooks as the Data Source and MSSQL (created before) as the User/System DSN, then click Next.

Note: An authorization dialog box will pop out if using RDS to connect QuickBooks. Select Yes, always, when a server is an available option, insert the right RDS Server name and password and then press OK as follows:

Destination Setup

     Set the Destination as the default SQL Server option and Next.

     Select the options to specify table copy or query and Next.

     Select source tables and views you want to copy and then Next. Here I take table Account as an example.

     Finally, press Finish completing the DTS Import/Export Wizard.

3. Waiting for Data Transfer

     I waited for the data copy from QODBC to MS SQL until it popped out a dialog box to say successful reproduction.

     Now we can see table Account in the test1 data source.

(470 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please complete the captcha below (we use this to prevent automated submissions).