Convert a mdb datatable to a comma delimited text file

[kornstyle]

How can I convert a datatable in MS Access into a comma delimited text file. thanks.

[econner]

If you have Microsoft Access, you can open the database and do an export and choose the save as "text file" option. If you do not have Microsoft Access, then you could write a simple routine to loop the data and write each field value out to a text file.

[Vasudevan Deepak Kumar]

Did you try using DTSWizard that comes with SQLServer Tools? Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://deepak.blogdrive.com/