Excel file into Sql
how to import an Excel file into Sql C# code in windows
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Abhishek JaiswalPosted Mar 17, 2015, 5:47 AM
You can use, any of these approaches
- SQL Insert Task based on SSIS
- SQL bulk query operations
- SQL Server configuration manager
- Import & Export option
- Using conversion codes at client side
For Further details go through my articlehttp://www.c-sharpcorner.com/UploadFile/2072a9/import-data-from-excel-to-sql-server-ssis/
:)
Rizwan AliPosted Mar 17, 2015, 5:45 AM
Vishnu BhangalePosted Mar 17, 2015, 5:11 AM
http://www.codeproject.com/Tips/636719/Import-MS-Excel-data-to-SQL-Server-table-using-Csh