Export wizard slow when using special delimiter

B

Bronsby

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.
 
B

Bronsby

Hi John
Thanks a lot for your answer - I have never tried to do this, so I am not
sure how to, but at least I now have an idea of what to look for.
 
Top