Uploading a excel database through a web page and converting data to sql? Help please.
-
Hi there Im looking at possibly needing a web based system where the client is going to upload a excel database via a web page. This data would then need to be converted to go into a sql database which i can use to display the data over the web in different ways. I use C# Any help will be greatly received.:) Thanks Adam
-
Hi there Im looking at possibly needing a web based system where the client is going to upload a excel database via a web page. This data would then need to be converted to go into a sql database which i can use to display the data over the web in different ways. I use C# Any help will be greatly received.:) Thanks Adam
Hi Adam, I guess that you know how to upload a file and save it on the server, and what you need to do next is to retrieve data from Excel and insert into a SQl database, ADO.NET can help you here. You can take a look at this KB[^] and its referenced documents to see to how to do that. If you are not familiar with ADO.NET , you can read the ADO.NET documentation[^]
-
Hi Adam, I guess that you know how to upload a file and save it on the server, and what you need to do next is to retrieve data from Excel and insert into a SQl database, ADO.NET can help you here. You can take a look at this KB[^] and its referenced documents to see to how to do that. If you are not familiar with ADO.NET , you can read the ADO.NET documentation[^]
Hi Thanks for the reply. I am aware of how to upload files to the server yes, it was how best to code a page to upload the excel sheet and the conversion to sql data after I needed to know. I shall have a look through those articles and see how I get on:) Thanks Adam