query to text file

[Keith G Hicks]

This is the only way I know of to create a text file from a query.

DoCmd.OutputTo acOutputQuery, "qrySomeQuery", acFormatTXT,
sDefaultFolder & sFileName

The trouble is that it's not coming out as I'd expected. I just need a
normal tab delimited text file without lines all over it and doesn't cut
data off short.

Is there another way where I have more control over the output?

Thanks,

Keith

 

[Keith G Hicks]

Ok. Sort of never mind with that question. I can use TransferText.
New problem.
I did this once before with a client years ago on an import and was able to
create an import specification. For some reason i can't create one now for
exporting. I think I have a corrupt access installation.
Anyway, on it's own it created a schema.ini and things are working ok except
for 2 things. The text file is COMMA delimited and has double quotes around
text fields. My client wants TAB delimited and no quotes. How can I
manually alter the schema.ini to do this?

Thanks,

Keith

 

[Keith G Hicks]

Well the problem was a corrupt Access installation. Did a repair and the
save specification for export worked fine.