Help with reading tab delimited excel file into SQL database!

I need to read in a tab delimited excel file into a SQL database using c#.

Anyone have any suggestions or know of any good resources that would help with t开发者_如何学JAVAhis?

---

For reading the CSV itsself I'd recommend you use A Fast CSV Reader from Sebastien Lorion because it will save you a lot of hassle parsing the CSV.

From here you could process each row line-by-line (loop over csv.ReadNextRecord()) or perhaps bulk copy it if you have a lot of data to avoid all the database hits.

I'm not an expert on this kind of thing, but that works for me anyway.

edit: sorry, I missed the Excel part of your question and assumed it was a flat file.

---

I figured it out. I just used streamreader and dbaccess.