.net - from excel to sql server -


i have excel files contains information need convert sql server database. problem face these information not structures database model need modifications.i using .net , i'm thinking use open xml sdk parse excel files, choice or there better ?

why not use ssis package if available?

http://www.mssqltips.com/sqlservertip/1393/import-excel-unicode-data-with-sql-server-integration-services/

you can execute ssis package recursively, or...

if need 1 time, i'd take @ ssms import / export wizard... not sure if excel, know .csvs, can use excel convert spreadsheets to. not fun if need bunch of times though, quicker other approach in regards time.


Comments