Data transfer

[JerryS]

Yes I am new to this.. I want to send information from a sql server to a textfile so it can be uploaded into a different sql base program.. Most of the information will go throught formatting changes then it will be written to a textfile..What will I have to create to store the information so I can write the textfile?

output information (out of database)

Start Date "1/5/2006 12:00:00 AM", End Date "5/15/2006 12:00:00 AM", Start Time " 1/1/1900 8:00:00 AM", End Time " 1/1/1900 9:00:00 AM", Daily Occ "M-F", Room" 34", Event ID "AMC152", Event Subtype "R", Section "1P", Confirmation "Confirmed", Number "10", Catagory "Campus Organization"

recieving information (into text file)
after parsing and canotation

Start Date "1/5/2006, End Date"5/15/2006", Start Time "8:00A", End Time "9:00A", Daily Occ "MTWRF", Room "034" Course "AMC152R1P", Confirmation"Confirmed", Number "10", Catagory "Campus Organization"

Thanks for any kind of help...

 

[JerryS]

Don't worry figured it out myself...

 

[vis781]

Hi jerry, if you post a question on this forum and arrive at an answer yourself, would it be possible in the future to post back with how you have solved it, as this could be a question that others may be searchig for an answer to.

 

[JerryS]

from dataset, to varibles for changes, to an arraylist, then to a streamwriter.