Loading

Excel file to DataBase insert

Punit Sharma

10y773.NET

Dear All,

I am having a Excel file that consists 40000 record. and i want to insert them into database. But the problem is that excel file consists different column name than Table Field and number of column less than the number of column of DB Table . and want to store record in bulk. then how it will possible. Please enlighten the way..

Thanks,

Punit Sharma

1 Reply

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

Raja T10y ago
Hi Punit, Please refer below links

http://www.c-sharpcorner.com/UploadFile/919746/importing-sql-server-table-in-excel-file/

https://www.mssqltips.com/sqlservertutorial/203/simple-way-to-import-data-into-sql-server/

http://searchsqlserver.techtarget.com/feature/The-SQL-Server-Import-and-Export-Wizard-how-to-guide

https://www.simple-talk.com/sql/ssis/moving-data-from-excel-to-sql-server---10-steps-to-follow/
0