开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜