Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts

    Access 2K: slow text import in Win 2K (Access 2000 SR-1)

    Anyone found text file imports to be slower in Access 2000 under Win 2000 than either Access 2000 under Win 98 or Access 97 under Win 2000?

    I have a procedure that imports a set of delimited text files using saved import specs. Some of these files are ridiculously small (say 15 rows by 10 columns/fields). Imports that used to take 2 seconds now take around 12 seconds each.

    Interestingly, large files aren't seriously slower than before, so there seems to be some additional overhead at the start of the import process...

    Jeremy

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2K: slow text import in Win 2K (Access 2000 SR-1)

    Is there a time difference if you link the files instead of importing them? I don't run Win2000, and from what I've seen of it on client machines, I'm not anxious to do so.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts

    Re: Access 2K: slow text import in Win 2K (Access 2000 SR-1)

    I haven't tried linking - usually with text files I set up code to import once and then play with the data in table format.

    In the grand scheme of things this "issue" doesn't really set me back - I was just wondering if it was a known/understood feature.

    Jeremy

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2K: slow text import in Win 2K (Access 2000 SR-1)

    I use linked files a lot because they don't bloat the database the way the imports and deletes do. And since Access 2000 bloats worse than all the other versions combined, anything that keeps it to a minimum is OK in my book.
    Charlotte

  5. #5
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts

    Re: Access 2K: slow text import in Win 2K (Access 2000 SR-1)

    that's fine, but this particular database is for calculations / modelling, so some of the fields in the original files need to be updated in place etc.

    For performance reasons if nothing else, I prefer to have the data in a table structure, and then I tidy up afterwards.

    Jeremy

Posting Permissions

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