Import from HTML

[Redskinsfan]

first off hi,

Well here's my prob, i created some forms using infopath and we upload them
to a outside server called buzzsaw, we dont have access to the data once is
stored there so the only thing i can do is fill out my form view it on that
server and save it as html to my machine..I want to extract the data that's
now in my saved html form using access, tryied the wizard but i get an error
message saying theres no data but if i look at the code in html i see that
data in there.. is there a certain type of commands i should write when
creating the form in infopath so it tells access theres data in there or do i
need to convert the html form into something else??? please help me out im
pretty new to all this. thanks in advance

 

['69 Camaro]

Hi.

is there a certain type of commands i should write when
creating the form in infopath so it tells access theres data in there or
do i
need to convert the html form into something else???

The wizard is looking for the tags and the data inside the table, which is
denoted by the <TABLE> and </TABLE> tags. If there's a lot of text or
script in addition to the table, the wizard gets confused, and you may have
to manually edit out the extraneous stuff in the HTML file after you
download it to your hard drive in order to get the wizard to recognize only
the data in the HTML table.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Redskinsfan]

could i save it as a different type of file, it seems as though there should
be an easier way to extract the data besides me having to hunt and extract it
manually. and yes the data has lot of scripts i mean your basic html code
page.

 

['69 Camaro]

Hi.

could i save it as a different type of file

One can save a Web page as HTML, MHT, or TXT. Perhaps TXT will be more
suitable than HTML. It's worth a try.

it seems as though there should
be an easier way to extract the data besides me having to hunt and extract
it
manually.

Many programmers use Perl or some other scripting language that handles
regular expressions to automatically extract only the text strings desired
from the file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.