Yes thats what I am talking about.
Dont you know how to call an exe from your "program"?
use the queryout option to select only the desired field.
PS: I just completed "programming" a console exe that
generate a CSV file (of selected fields) and then upload it to a remote FTP
Server using VB.NET.
--
Roji. P. Thomas
SQL Server Programmer
--------------------------------------
"Ashish Kanoongo" <as*****@armoursoftware.com> wrote in message news:ux**************@TK2MSFTNGP11.phx.gbl...
That I know, I want to do it thru programming .
"Roji. P. Thomas" <la********@somewhere.com> wrote in message news:OY**************@TK2MSFTNGP09.phx.gbl...
You can use bcp to generate the CSV File,
and any FTP Client component to upload the file.
--
Roji. P. Thomas
SQL Server Programmer
--------------------------------------
"Ashish Kanoongo" <as*****@armoursoftware.com> wrote in message news:eI*************@TK2MSFTNGP11.phx.gbl...
Hello There
I want to generated a csv file from sql server table, in which I would like to create a asp page which display a field list with a check box. Then whatever check box I selected, and click on generate button, then a CSV text fill will generate depending on sellected field with the field header and uploaded to FTP server.
Is there any article on this or I am very much thankful, if someone help in this matter.
Ashish K
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.559 / Virus Database: 351 - Release Date: 01/07/2004