Binding a CSV to a DataSet

I think parsing into the "vanilla" xml file, is defintely the way to go gives you more flexiblity, and shouldn't take long at all.

Well, you can create a DSN programmatically but not the mappings. So the answer is yes. You have to setup CSV mappings manually. ================= Okay, so if I use ODBC, do I still have to setup all of the mappings manually? -James

Jeez, I just can't type today. "I might be worth..." -=> "It might be worth..."

Well, in the case of delimited files, it's pretty "hands off" once you create the DSN (which you can do programatically too). I might be worth just taking a little time and parsing the data into a plain vanilla xml file and use the native binding available for xml within .net.

Okay, so if I use ODBC, do I still have to setup all of the mappings manually? -James

You can ODBC data provider to read and write text files. See the following URLs for more details: http://www.c-sharpcorner.com/database/Connect/ConnectODBCText.asp http://www.c-sharpcorner.com/Code/2002/Nov/AccessTextDb.asp