How can I generate a table in sql from a .txt file?
Posted on 2009-07-06
I have a tab-delimited text file with something like 66 columns/fields from amazon. I want to generate a table so that I don't have to explicitly define it myself much like I can do in Excel. However, I have created a program that writes an Schema.ini file that already explicity describes the file from which I make an OldDbConnection, OleDbDataAdapter, and subsequently fill into a dataSeta. So , I believe I have a couple options? Thanks.