The real way to do this is to first optimize your tables by using the [ Load Updated Data ] or [ Reload All Data ] (if you have just started using QODBC) option in the QODBC setup screen.
Once optimization is completed (the time this takes is dependent on the size of your company file), use queries, not copy tables, with the NOSYNC command in the DTS Import/Export Wizard:
like this for each of the tables you wish to import:
select * from Invoice NOSYNC select * from InvoiceLine NOSYNC
See: Using DTS to Load QuickBooks Data into Microsoft SQL Server for more on how to transfer all the QuickBooks tables. |