[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
Windows XP System
QuickBooks Enterprise Solution 9.0 (USA)
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 setup 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 it 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 (which has been created before) as the User/System DSN, then click Next.
Note: If using RDS to connect QuickBooks, here an authorize dialog box will pop out. Select Yes, always, when server is available option, insert the right RDS Server name and password and then press OK as follows:
Set the Destination 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
Waiting for the data copy from QODBC to MS SQL till it pops out a dialog box to say successful copy.
Now we can see table Account in test1 data source.