This is a multi-part message in MIME format.
------=_NextPart_000_007B_01C3DC1F.7CDC86F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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=20
generate a CSV file (of selected fields) and then upload it to a remote =
FTP
Server using VB.NET.=20
--=20
Roji. P. Thomas
SQL Server Programmer=20
--------------------------------------
"Ashish Kanoongo" <
ashishk@armoursoftware.com>wrote in message =
That I know, I want to do it thru programming .
"Roji. P. Thomas" <
lazydragon@somewhere.com>wrote in message =
You can use bcp to generate the CSV File,
and any FTP Client component to upload the file.
--=20
Roji. P. Thomas
SQL Server Programmer=20
--------------------------------------
"Ashish Kanoongo" <
ashishk@armoursoftware.com>wrote in message =
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 (
www.grisoft.com).">
www.grisoft.com).
Version: 6.0.559 / Virus Database: 351 - Release Date: 01/07/2004
------=_NextPart_000_007B_01C3DC1F.7CDC86F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Yes thats what I am talking =
about.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Dont you know how to call an exe from =
your=20
"program"?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>use the queryout option to select only =
the desired=20
field.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>PS: I just completed "programming" a =
console exe=20
that </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>generate a CSV file (of selected =
fields) and then=20
upload it to a remote FTP</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Server using VB.NET. </FONT></DIV>
<DIV><BR>-- <BR>Roji. P. Thomas<BR>SQL Server Programmer=20
<BR>--------------------------------------</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ashish Kanoongo" <<A=20
=
href=3D"mailto:
ashishk@armoursoftware.com">
ashishk@armoursoftware.com</A>=
>=20
wrote in message <A=20
=
href=3D"news:
uxS64x12DHA.2000@TK2MSFTNGP11.phx.gbl">news:uxS64x12DHA.2000=
@TK2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>That I know, I want to do it thru =
programming=20
.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Roji. P. Thomas" <<A=20
=
href=3D"mailto:
lazydragon@somewhere.com">
lazydragon@somewhere.com</A>>=
=20
wrote in message <A=20
=
href=3D"news:
OYwXkl12DHA.2948@TK2MSFTNGP09.phx.gbl">news:OYwXkl12DHA.2948=
@TK2MSFTNGP09.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>You can use bcp to generate the CSV =
File,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>and any FTP Client component to =
upload the=20
file.</FONT></DIV>
<DIV><BR>-- <BR>Roji. P. Thomas<BR>SQL Server Programmer=20
<BR>--------------------------------------</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ashish Kanoongo" <<A=20
=
href=3D"mailto:
ashishk@armoursoftware.com">
ashishk@armoursoftware.com</A>=
>=20
wrote in message <A=20
=
href=3D"news:
eIFEnN12DHA.556@TK2MSFTNGP11.phx.gbl">news:eIFEnN12DHA.556@T=
K2MSFTNGP11.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hello There</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I want to generated a csv file =
from sql=20
server table, in which I would like to create a asp page which =
display a=20
field list with a check box. Then whatever check box I selected, =
and click=20
on generate button, then a CSV text fill will generate depending =
on=20
sellected field with the field header and uploaded to FTP=20
server.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Is there any article on this or I =
am very=20
much thankful, if someone help in this matter.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Ashish K</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><BR>---<BR>Outgoing mail is =
certified Virus=20
Free.<BR>Checked by AVG anti-virus system (<A=20
=
href=3D"
www.grisoft.com">
www.grisoft.com</A>).<BR>Version:">
www.grisoft.com">
www.grisoft.com</A>).<BR>Version: =
6.0.559 / Virus Database: 351 - Release Date:=20
=
01/07/2004</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></HT=
ML>
------=_NextPart_000_007B_01C3DC1F.7CDC86F0--
-
