1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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

    Joined:
    Jan 14, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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 New Member

    Joined:
    Mar 21, 2010
    Messages:
    848
    Likes Received:
    224
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    India
    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