Excel Importing External Data Keeps Hanging

Posted on 2011-10-29
Last Modified: 2012-05-12
Everytime I try to import data from Sage (My Accounts Package) using Excel import data my system hangs and I notice a huge file of 180GB in my temp folder.  This happens at the point of excel bringing up the tables for me to associate with each other.

Any ideas?
Question by:Simonrepro
    LVL 5

    Accepted Solution

    Are you sure you are using the lastest ODBC drivers from Sage ?
    Are u using the regular Wizard or VBA ?
    Can you post your macro if you are using one ?

    Author Comment

    Yes this is the latest odbc drivers from sage, also there is no macro yet and I am just going to import data in excel choosing the required fields I want, then it says I have to link table, at this point it hangs and creates this huge file.

    Author Closing Comment

    thanks but I figured it myself by going into the query itself and turning off the auto run button and making the adjustments before running as the reason it was hanging was there were too many results.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    760 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

    7 Experts available now in Live!

    Get 1:1 Help Now