Export wizard slow when using special delimiter

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top