1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

auto fill data from excel into a web page

Discussion in 'Meet and Greet' started by ashmc82, Jan 14, 2011.

  1. ashmc82

    ashmc82 New Member

    Jan 14, 2011
    Likes Received:
    Trophy Points:
    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??
  2. lionaneesh

    lionaneesh Active Member

    Mar 21, 2010
    Likes Received:
    Trophy Points:
    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/archive/2006/05/31/2976.aspx]
    3. Use PHP or other languages to extract the Data from your database
    ashmc82 and shabbir like this.

Share This Page