Loading

load excel file into sql table using wpf C#

Mai Hu Na

hi
i want to insert data from excel file to sql table using wpf (c# 2010)
plz help

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
Accepted answer
You can directly import in Sql server. Use Openrowset

Check this

http://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm
Mai Hu Na14y ago
hi Sukesh Marla, but i want to load thausand(1000) of files thats why i am creating wpf application plz help
Sukesh Marla14y ago
Why dont you use Sql Servers in build feature, i.e, Import export Wizard