Select Excel File as Database table in runtime - ASP.Net - C#
-
I am developing a web application, which have to get the data from selected Excel file and save it in SQL Database. I want to select Excel File in runtime using the FileUpload control. Is this possible..? Please guide me..
-
I am developing a web application, which have to get the data from selected Excel file and save it in SQL Database. I want to select Excel File in runtime using the FileUpload control. Is this possible..? Please guide me..
hi SravanKumar-A, yes it's possible.... first, his first save the file when uploaded, this means stored on the Server side, here you set it to accommodate PathLocation Files uploaded the results .. then, you read his file based PathLocation excel file it in the store .. how to read the contents of the data from the Excel file, you can googling, a lot of his examples .. You must read the contents of his excel how many rows, then you loop through the contents of each row to get her, then you input into a database row-a row .. after that you delete the file upload it if you save the file you do not use anymore .. yes, this is just a logical course to determine the appropriate code logic what its like ..