Export wizard slow when using special delimiter

G

Guest

I have an Access database with many linked tables. When I Export to txt-file,
and select "other" delimiter, the export wizard apparently fetches all rows
before I can fill out the input-field for the delimiter I want to use. Since
the tables are linked, and the query is complex, it takes aprox 15 mins to
change delimiter. Any ways to do it faster? Thanks in advance.
 
J

John Nurick

Hi Bronsby,

If this is a routine task, create and save an export specification with
the right delimiter and other details. Then crate a little VBA procedure
that uses DoCmd.TransferText to export the query using the
specification.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to change default values (delimiter etc) for Export Wizard 6
Saving an Export Text Wizard for an MSAccess Table or Query? 1
Export data - default delimiter 1
Export specification not use? 1
Confguration file for export 5
Export delimiters/decimals 2
Determine delimiter in csv or txt file 6
Export Results of Access 2000 query to text file. 2

Top