Select statement : COMMA DELIMITED

[RemingtonSteel]

Hello folks,

How can I convert a SQL statement result into a comma delimited file?

For Example:

Select * from customers into [delimited file] ?

Thanks guys!

 

[bborissov]

Select * from customers into CURSOR crsTest
COPY TO MyCommaFile CSV
** or COPY TO MyCommaFile DELIMITED

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[RemingtonSteel]

Thanks Borislav!

 

[RemingtonSteel]

Hello Again!
I was wondering why the COPY TO command doesn't work on Query Analyzer. Any thoughts on this?

Thanks a lot!

 

[MarciaAkins]

I was wondering why the COPY TO command doesn't work on Query Analyzer. Any thoughts on this?

Because copy to is a VFP command and SQL Server doesn't understand VFP.

What you need to do is to connect to SQL Server from VFP and use SQLEXEC to run your query. This will give you a local VFP cuors and you can use the COPY TO command on that,

See SQLCONNECT(), SQLSTRINGCONNECT(), and SQLEXEC() in the on-line help.

Alternatively, you can create a remote view in VFP and use the COPY TO command on that.

Marcia G. Akins

http://www.TightlineComputers.com

 

[RemingtonSteel]

Thanks Marcia. I will try that.

 

[Mike Lewis]

Or, if you prefer to work exclusively in the Query Analyzer, you could do it with bcp.

This is not tested, but it should work OK:

SELECT * INTO #TempTable FROM MyTable
BCP #TempTable out c:\data\MyTable.txt -c -t,

(Note the comma after the -t - that's the delimiter.)

But personally I'd do as Marcia suggested.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk