importing data to csv file
Hi Team, i want to import data from a table to a .csv file i am very sure how to do this the source/destination connection, what components to be used for destination(csv). Please help me with an example or any forum which has the examples, thanks in advance Regards, Eshwar.
May 17th, 2011 12:32am

you can use oledb source connecting to your database table and flat file destination to destination csv and do mappings correctly. or also you can use Import/Export Wizard just set source as database, and destination as csv flat file.http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 12:42am

Thanks Reza, I am able to do.. but how to handle the "," with in the data like if address has a comma within it then data after comma will go to other fields. Regards, Eshwar
May 17th, 2011 1:11am

Thanks Reza, I am able to do.. but how to handle the "," with in the data like if address has a comma within it then data after comma will go to other fields. Regards, Eshwar you probably have your fields qualified with text, and to overcome the comma inside values issue, I had complete sample here to solve it: http://www.rad.pasfu.com/index.php?/archives/13-Problem-with-comma-values-in-Comma-Delimited-File.htmlhttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 1:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics