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.
 

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

Export Delimited 1
how to change default values (delimiter etc) for Export Wizard 6
Export to Tab delimited text file 4
Delimited Export Specification - independent of table 3
Export more rows to a tab delimited file 1
Fixed Width - No delimiters - ASCII Text File 7
Export to Delimited Txt file using Macro 1
Exporting Table to Text file including Fielnames 2

Back
Top