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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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","GLTRANS","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"," "," "
 
Eduardo78 said:
I would like to find a way to convert a MS SQL table with data into a
coma delimited .DAT file.
Click to expand...

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[.*]").
 
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.
Click to expand...

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[.*]").
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looking for macro that converts a table that I can import into Access 17
Complex 2 table formula 4
How do I sum different sized ranges? 3
How do I retrieve Cost from a grid using text drop down lists? 3
using a triple-nested for...next loop 5
How can find a value using two different matching criteria? 6
Copy Code and a sort problem 1
Excel 2002: How to fill up text for like items ? 4

Back
Top