[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

Importing Data

I am importing upc codes in Quickbooks 8.0, using the data import tool. I have about 6000 items to import and it is taking about 14 hours for Quickbooks 8.0 to process. Is there a easier or faster way of doing this. That is a huge amount of time and my store is never closed for that length of time.

If I quit in the middle of it, I have to start all over.

Any suggestions would be very welcome.

  • 2
1 Solution
Bill BachPresidentCommented:
You could try the QODBC tool (www.qodbc.com) and write some SQL INSERT statements, and see if that is any faster.  Get the Read-Write version as a 30-day trial and see if this works before purchasing it.  

The performance may also be related to the underlying database updates that must be made (which typically require updating multiple records, in addition to auditing if you are using that).  If that is the case, then this tool won't provide you with any performance gains, and you'll need to break up your import down into some more manageable chunks, perhaps doing 500 imports per night or so.
Bill BachPresidentCommented:
The only way to tell if the QODBC import is faster for that data set is to try it on THAT data set.

The second suggestion is pretty obvious and will also be a good option.

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now