Results 1 to 4 of 4
  1. #1
    kestefon is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2013
    Posts
    108

    Settings To Improve Export Text Wizard Speed?

    Hi,



    I am exporting a large query to a delimited text file. I'm finding that it takes more than 5 minutes just to get the Export Text Wizard to load, and I'm guessing that's because Access is running the query as it loads the wizard.

    Is there a setting I can toggle off to help speed up this process? I don't mind if the query itself takes a while to export, but the screen-loading time is driving me nuts.

  2. #2
    atuhacek is offline New
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Location
    Michigan
    Posts
    61
    You might try dumping the information into a temp table and the exporting after completion. Access doesn't multithread so you can't send it to the background.

  3. #3
    kestefon is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2013
    Posts
    108
    How would I go about dumping it into a temp table? Would that eat up as much memory as a Make Table query? I ask because the query in question is several gigs large when exported.

  4. #4
    atuhacek is offline New
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Location
    Michigan
    Posts
    61
    Not sure anything is going to help with a file that size. But creating a temp table with vba will keep it from running both at the same time.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 08-21-2013, 12:32 AM
  2. Rich text default settings
    By Sanyusha in forum Forms
    Replies: 2
    Last Post: 06-12-2013, 02:28 AM
  3. Speed Up Access 2007 and export to Excel
    By Bigmix in forum Import/Export Data
    Replies: 1
    Last Post: 02-28-2013, 03:35 AM
  4. Replies: 1
    Last Post: 08-05-2011, 05:16 PM
  5. Improve query speed
    By FMJO in forum Queries
    Replies: 3
    Last Post: 02-10-2011, 08:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums