Access SQL: exporting to CSV or TXT file

[tricard]

Hi there,

I was curious to know if there is a way to export a query to a csv or
txt file through SQL in access (like the SELECT INTO OUTFILE in mysql).
I have tried using this, but it does not seem to work.

Tim

[Granny Spitz via AccessMonster.com]

tr*****@gmail.com wrote:

>Hi there,

I was curious to know if there is a way to export a query to a csv or
txt file through SQL in access (like the SELECT INTO OUTFILE in mysql).

You sure can. Here's an example:

SELECT FieldName1, FieldName2, FieldName3 INTO [Text;HDR=YES;DATABASE=C:\Test\
].Results.txt
FROM TableName
WHERE (FieldName1 < 20);

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1

[Granny Spitz via AccessMonster.com]

I'm sorry. That got split up in the browser. The second and third lines of
text in the SQL should all be one line, with no spaces. It should read with
only four lines, not five. This is all one line:

[Text;HDR=YES;DATABASE=C:\Test\].Results.txt

--
Message posted via http://www.accessmonster.com

[tricard]

Thank you very much for the help! Is there any documentation regarding
the various options that can be used for the output file (i.e. HDR,
DATABASE etc.)?

Tim

Granny Spitz via AccessMonster.com wrote:

I'm sorry. That got split up in the browser. The second and third lines of
text in the SQL should all be one line, with no spaces. It should read with
only four lines, not five. This is all one line:

[Text;HDR=YES;DATABASE=C:\Test\].Results.txt

--
Message posted via http://www.accessmonster.com

[Granny Spitz via AccessMonster.com]

tr*****@gmail.com wrote:

Is there any documentation regarding
the various options that can be used for the output file

Not specifically for SQL. I found *most* of what I needed in the Access 97
help files, but not in the newer versions. It was really hard to find, but
the topic was regarding connection strings to various file types, including
Excel spreadsheets, dBase files, Paradox, etc.

Here are some online examples of the syntax:

http://support.microsoft.com/kb/262537/en-us

http://support.microsoft.com/kb/326548/en-us

Documentation for text file formats:

http://msdn.microsoft.com/library/de...ext_format.asp
http://msdn.microsoft.com/library/de...a_ini_file.asp
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200609/1