load excel file into sql table using wpf C#

Question

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

Santhosh Kumar Jayaraman · 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 Na · Answer

hi Sukesh Marla but i want to load thausand(1000) of files thats why i am creating wpf application plz help

Sukesh Marla · Answer

Why dont you use Sql Servers in build feature i.e Import export Wizard