Querying CSV file using ODBC

[Wayne Phipps]

I don't know if anyone here can help me, I have a working application that uses an ODBC connection to retrieve data from a CSV file. The only problem I have is that it always treats the first line as Column Names but our company gets sent data from different sources, some include Column Names, others don't. I would like to make the application more flexible and enable it to work with either format files without having to write a schema.ini file for each import. The connection string is something like: "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=C:\MyTest;" Can the connection string be changed to indicate if column info is not included? Regards Wayne Phipps ____________ Time is the greatest teacher... unfortunately, it kills all of its students LearnVisualStudio.Net