[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 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:
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.