Importing Data

Posted on 2009-04-16
Last Modified: 2013-12-20
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.

Question by:domask12
    LVL 28

    Accepted Solution

    You could try the QODBC tool ( 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.
    LVL 28

    Expert Comment

    by:Bill Bach
    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Are you having trouble connecting or getting your iPhone / Samsung device(s) to sync with Microsoft Exchange Server?   What have you tried?   What haven't you tried?
    Check out this infographic on what you need to make a good email signature that will work perfectly for your organization.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now