Results 1 to 1 of 1

Convert portion of html page into Excel table

Threaded View

brucemc Convert portion of html page... 06-05-2013, 04:44 PM
  1. #1
    Registered User
    Join Date
    03-27-2006
    Posts
    70

    Convert portion of html page into Excel table

    Good Whatevertimeofdayitis!

    Hey folks. Still struggling with trying to get decent employment, but in the meantime I am doing volunteer work for a very worthy cause, but since I am very new to it and it deals with HIPAA and ADA protected materials, I have to work with highly abstract information at this point; I neither wish to break any laws, breach anyone's privacy nor tick anyone off...

    Anyway, the organization is in the field of helping people and has a website where forms are filled in. When an applicant has not completely filled in a form, they send copies of the contact page to folks like me to follow them up and see if they need help in filling in the rest. I get an html image of the form (as I intend to attach hereto, though as you will see it has been highly modified as to answers and some of the questions) and not a correlated copy of the sql db that is probably behind it all.

    Is there a nice way of converting a page such as the attached to either an Excel spreadsheet, Access db or file that could be read by either that would simply display the questions and answers? I am way too new to probe for direct access to the underlying server materials nor question their way of doing things, but as there are a number of these that need be followed up with, each on it's own html page, it would be nice to have a way to import the information programatically rather than open the html in one screen, Excel in another screen, and cut and paste fields for the first, then the same for the second, then the same for the third and so on and so forth...

    Working with Office 2010 and a bit rusty but I can get back up to speed with a little (well, maybe a little bit more than little) help.

    Thank-you for your thoughts!
    -Bruce

    p.s.: OK, so I "altered the rules". I took the html file and stuck a txt extension on it so it would take. Just rename it to html from txt once you get it to load in the browser, open directly into your browser, or if you are that good, just look at the html as txt in a text editor! Moderator: Please advise if what I have done is in violation of any rules and accept my apologies.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1