auto fill data from excel into a web page

ashmc82's Avatar
Newbie Member
I am totally new to the world of VB and .net but have intermediate experience using excel.

I want to be able to take info from an excel sheet that will automatically update or show in certain text boxes in a web page or pages on a particular site.

Simply my excel sheet contains material data. This material must be transported under strict Customs & Excise rules so before I can move it on the road the relevant information must be submitted into the HMRC web portal.

I want to know if it is possible to create an application that will take the data from my excel sheet and enter it into the web portal I think in text boxes, the right information, in the right place, at the right time dependant on which page I'm on within the site, using visual basic????

Can anybody let me know if this would be possible and if so where to start??
lionaneesh's Avatar, Join Date: Mar 2010
Invasive contributor
Quote:
Originally Posted by ashmc82 View Post
I am totally new to the world of VB and .net but have intermediate experience using excel.

I want to be able to take info from an excel sheet that will automatically update or show in certain text boxes in a web page or pages on a particular site.

Simply my excel sheet contains material data. This material must be transported under strict Customs & Excise rules so before I can move it on the road the relevant information must be submitted into the HMRC web portal.

I want to know if it is possible to create an application that will take the data from my excel sheet and enter it into the web portal I think in text boxes, the right information, in the right place, at the right time dependant on which page I'm on within the site, using visual basic????

Can anybody let me know if this would be possible and if so where to start??
Yes it is possible ...
What you have to do is :-

1. Create a SQL Database of your excel sheet
2. Import the Excel Sheet into A SQL Database [http://www.davidhayden.com/blog/dave...5/31/2976.aspx]
3. Use PHP or other languages to extract the Data from your database
ashmc82, shabbir likes this