Results 1 to 7 of 7

Thread: importing data

  1. #1
    Join Date
    Oct 2004
    Posts
    57

    Unanswered: importing data

    i run office 2000 on an xp operating sytem...whenever i try to import data from an external source, excel locks up. has anyone encountered this before? if so, is there a known fix? thanks for the help....

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    When using Microsft query, with the size of recordsets i look at it can take an absoloute age to come through, sometimes as much as 1/2 an hour,
    if i have to do something like this i usually try to let it run on a seperate machine
    if you give it enough time it will probably come through

    how long have you let it run before, what size of file are you trying to import, what kind of system are you importing from - i usually run to a SQL server which takes longer than running from Access

    Dave

  3. #3
    Join Date
    Mar 2005
    Posts
    4

    Exporting data

    there shouldn't be any problem with the os version you have and the office version you have.
    maybe there is some complication with you office or os.

    at work we are using office2000 on a 98 platform, there doesn't seem to be any problems with the data transfers we do.

    restart the program, or computer and try again... where is it that you are importing the data from - Access? or is it vice-verse?

  4. #4
    Join Date
    Oct 2004
    Posts
    57
    ive let it run for almost 4 hours.....it happens when i try to import data from anywhere...access, oracle, or any outside source. ive tried rebooting and reinstalling...any ideas?

  5. #5
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Have you tried connecting through an ADO recordset then writing this recordset to a worksheet, although this is slow it may help pinpoint the problem whether its network or down to your local instance of MS Query

    Just a thought

  6. #6
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    you could also check to see if this is the problem

    http://support.microsoft.com/kb/q105136/

    ive done some searching and this is the best i can come up with

  7. #7
    Join Date
    Oct 2004
    Posts
    57
    Thanks for the suggestions David...thats what makes this weird...I can export data into Excel, but I cannot import (not even from my local drive)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •