Using Visual Basic 6.0, How can I convert a SQL table into a .DAT

[Eduardo78]

Ok, I would like to find a way to convert a MS SQL table with data into a
coma delimited .DAT file.

This is the format that i am trying to get:

"6020051013A",1,,"0010000","100620",60,"10132005", ,"INCOMING",,,-3126.45,-3126.45,,,,,"10132005"," "," "
"6020051013A",2,,"0010000","287000",60,"10132005", ,"INCOMING",,,-410765.07,-410765.07,,,,,"10132005"," "," "
"6020051013A",3,,"0010000","187010",60,"10132005", ,"INCOMING",,,-20491.85,-20491.85,,,,,"10132005"," "," "
"6020051013A",4,,"0010000","187010",60,"10132005", ,"INCOMING",,,-0.02,-0.02,,,,,"10132005"," "," "
"6020051013A",5,,"0010000","100625",60,"10132005", ,"INCOMING",,,-1847366.42,-1847366.42,,,,,"10132005"," "," "
"6020051013A",6,,"0010000","287000",60,"10132005", ,"INCOMING",,,-11436.16,-11436.16,,,,,"10132005"," "," "
"6020051013A",7,,"0010000","187010",60,"10132005", ,"INCOMING",,,-400.00,-400.00,,,,,"10132005"," "," "
"6020051013A",8,,"0010000","100625",60,"10132005", ,"INCOMING",,,3126.45,3126.45,,,,,"10132005"," "," "
"6020051013A",9,,"0010000","187010",60,"10132005", ,"INCOMING",,,410765.07,410765.07,,,,,"10132005 "," "," "
"6020051013A",10,,"0010000","106000",60,"10132005" ,,"INCOMING",,,20491.85,20491.85,,,,,"10132005","G LTRANS","GLTRN"
"6020051013A",11,,"0014250","595010",60,"10132005" ,,"INCOMING",,,0.02,0.02,,,,,"10132005"," "," "
"6020051013A",12,,"0010000","187010",60,"10132005" ,,"INCOMING",,,1847366.42,1847366.42,,,,,"10132005 "," "," "
"6020051013A",13,,"0010000","187010",60,"10132005" ,,"INCOMING",,,11436.16,11436.16,,,,,"10132005", " "," "
"6020051013A",14,,"0010000","255055",60,"10132005" ,,"INCOMING",,,400.00,400.00,,,,,"10132005"," "," "

[Herfried K. Wagner [MVP]]

"Eduardo78" <Ed*******@discussions.microsoft.com> schrieb:

I would like to find a way to convert a MS SQL table with data into a
coma delimited .DAT file.

This is a VB.NET group. You will more likely get an answer to your question
in the VB6 database-related groups ("microsoft.public.vb.database[.*]").

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Eduardo78]

Using VB.NET (Ok a.h.) sorry!

"> > I would like to find a way to convert a MS SQL table with data into a

coma delimited .DAT file.

This is a VB.NET group. You will more likely get an answer to your question
in the VB6 database-related groups ("microsoft.public.vb.database[.*]").

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>