Quickbooks Conversion Using ODBC extremely slow

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Dan (Dan_at_discussions.microsoft.com)
Date: 02/23/05 

Date: Wed, 23 Feb 2005 11:03:03 -0800

Hi,

On a monthly basis we have to use the "get external data" feature in access
to import a table from quickbooks.

Each month the process adds on about 15 minutes for the conversion. We have
condensed quickbooks and tried the conversion locally, and in a new empty
database but get the same results. We are now sitting at about 3 1/2 hours to
run the conversion, and any other activity on the computer locks up the
conversion so that it will not complete.

Does anyone have any ideas on things we could try to help speed this up. I
have looked at http://www.granite.ab.ca/accsmstr.htm and tried some of the
applicable items.

Thanks !
Dan

Relevant Pages

  • Re: E*Trade export to QuickBooks
    ... The Quicken program cannot convert QuickBooks data because QuickBooks data files contain many elements for which Quicken has no support mechanism. ... QuickBooks products of the same or newer version of your Quicken product, will generally convert Quicken data files (except your Investment Accounts). ... Quicken to QuickBooks data conversion is a one-way conversion. ...
    (misc.invest.stocks)
  • Re: E*Trade export to QuickBooks
    ... The Quicken program cannot convert QuickBooks data because QuickBooks data files ... convert Quicken data files (except your Investment Accounts). ... Quicken to QuickBooks data conversion is a one-way conversion. ... to buy Quicken just for E*Trade, create a new Quicken setup, then ...
    (misc.invest.stocks)
  • Re: Quickbooks Conversion Using ODBC extremely slow
    ... Hi Dan, ... One thing I can tell you is Quickbooks is ridiculously slow to begin with. ... have 3 or so users using QB on fast computers. ... > Each month the process adds on about 15 minutes for the conversion. ...
    (microsoft.public.access.externaldata)
  • Re: SW2006 file format
    ... with conversion problems and submitting conversion errors even before I get ... CAD program and are therefore biased - as am I for SolidWorks - but I have ... > I agree that some feature types cannot import/export due to new feature ... > own file structure for translations. ...
    (comp.cad.solidworks)
  • Re: Switching between color spaces
    ... Chinese is also a very simple language, and it has worked for millennia. ... Who is doing that conversion? ... PostScript when printing to a PostScript printer and use the PS printer ... driver's "pass through" feature. ...
    (comp.lang.postscript)