Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Meet and Greet (http://www.go4expert.com/community/meet-and-greet/)
-   -   auto fill data from excel into a web page (http://www.go4expert.com/community/auto-data-excel-web-page-t24539/)

ashmc82 14Jan2011 16:20

auto fill data from excel into a web page
 
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 14Jan2011 16:30

Re: auto fill data from excel into a web page
 
Quote:

Originally Posted by ashmc82 (Post 77414)
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


All times are GMT +5.5. The time now is 18:40.