How to store or save excel file content to multiple table(minimum 1 column each for 5 table), please response quickly,
Thanks
NKunder
Dear @NKunder,
please refer below, it might be help you
http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-excel-file-records-into-sql-server-database-using/
https://www.aspsnippets.com/Articles/How-to-Import-Excel-Sheet-data-into-SQL-Server-using-ASPNet.aspx
https://www.codeproject.com/Questions/500787/saveplusdataplusfromplusexcelplussheetplustoplussq
hi NKunder
http://www.codedigest.com/Articles/ASPNET/400_ImportUpload_Excel_Sheet_data_to_Sql_Server_in_C__and_AspNet.aspx
https://chiragrdarji.wordpress.com/2007/08/31/storing-and-retrieving-docpdfxls-files-in-sql-server/
http://www.dotnetspider.com/resources/45059-Export-Excel-To-SQL-DataBase.aspx
Hi NKunder,
Please explain the below statement in more details.
NKunder says: store or save excel file content to multiple table(minimum 1 column each for 5 table)
store or save excel file content to multiple table(minimum 1 column each for 5 table)
i need to save excel content to different different table.
Ex: If excel sheet contains 10 columns, first two column of excel sheet to first table, second two column to second table and remaing 6 column to third table
Share your Excel file sample data and also the Tabl structure and also if some coding if you have done.
© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.