Re: Export wizard slow when using special delimiter

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Nurick <j.mapSoN.nurick@xxxxxxxxxxxxxx>
Date: Wed, 14 Mar 2007 05:10:26 -0100

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.

On Tue, 13 Mar 2007 05:57:08 -0700, Bronsby
<Bronsby@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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.

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.
.

Prev by Date: Re: Exporting table to .csv file, then importing .csv file back to
Next by Date: Re: importing from Word label doc to Access
Previous by thread: Re: Exporting from Access to Excel issue
Next by thread: Re: importing from Word label doc to Access
Index(es):
- Date
- Thread

Relevant Pages

Re: Not the usual memo truncating issues
... One way is to use the WriteToFile() function at ... You can simply include it in a query, like this, and open the query: ... >Thanks John. ... >>>and delimiter that is available, ...
(microsoft.public.access.externaldata)
Re: Error in updating memo field
... - order_no is a Number column so I will not use a delimiter around the value ... that are in the data so they will be treated as literal apostrophes instead ... a new query in Design View without selecting any tables, switch to SQL View, ... Please reply to the newsgroup. ...
(microsoft.public.inetserver.asp.db)
Re: Exporting to a text file Question
... I am only exporting one record at a time so delineation between ... You need to do a bit of preliminary work first. ... Save the query. ... Set the File Format to Delimited, the space as Delimiter, and ...
(microsoft.public.access.modulesdaovba)
RE: How to extract portion of text
... Public Function fnSplitPart(SomeValue As Variant, Delimiter As String, Part ... Dim MyArray() As String ... I really need help to solve for the 4th part query. ...
(microsoft.public.access.queries)
Re: Problem to write a query result in a text file.
... - source doesn't have proper field delimiters and end of record delimiter ... - select query and output query aren't as identical as thought ... I have an access database that write several queries result into several ... In a particular one it's happening a strange thing. ...
(microsoft.public.access.queries)