Replacing partial text in an HTML files

[Lauren Quantrell]

I have an HTML file named myHTML.htm

It looks like this:

<great HTML code>
<more great HTML code>
<even more great HTML code>

<insert HTML here>

</great HTML code>
</more great HTML code>
</even more great HTML code>

I need to use my Access database to pull data from a table and insert
it into the HTML file
where it reads: <insert HTML here>

Doable?

Any help is appreciated,
lq

[Larry Linson]

It should be doable... the HTML file is a text file, so you can read it with
Access VBA I/O statements, e.g., Input#, just like any other text file, and
write a new file with data merged from the original and your table, with
appropriate statements, e.g., Print#.

The only part that could be tricky is to determine just what records from
your Access table you should retrieve and insert -- my recollection is that
you are a long-time participant here, and know how to retrieve data from
tables with VBA and DAO (or ADO), so I won't offer suggestions on that part.

Larry Linson
Microsoft Access MVP

"Lauren Quantrell" <la*************@hotmail.comwrote in message
news:5a**********************************@s13g2000 prd.googlegroups.com...

>I have an HTML file named myHTML.htm

It looks like this:

<great HTML code>
<more great HTML code>
<even more great HTML code>

<insert HTML here>

</great HTML code>
</more great HTML code>
</even more great HTML code>

I need to use my Access database to pull data from a table and insert
it into the HTML file
where it reads: <insert HTML here>

Doable?

Any help is appreciated,
lq

[Tom van Stiphout]

On Fri, 18 Jan 2008 19:44:38 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

You could certainly treat an HTML file as a text file, but you could
do the same with a database file (OK, perhaps as a binary file). The
reason we don't is that there is a better object model available, be
it DAO in the case of an MDB file, or DOM or XML in the case of HTML.

-Tom.

>It should be doable... the HTML file is a text file, so you can read it with
Access VBA I/O statements, e.g., Input#, just like any other text file, and
write a new file with data merged from the original and your table, with
appropriate statements, e.g., Print#.

The only part that could be tricky is to determine just what records from
your Access table you should retrieve and insert -- my recollection is that
you are a long-time participant here, and know how to retrieve data from
tables with VBA and DAO (or ADO), so I won't offer suggestions on that part.

Larry Linson
Microsoft Access MVP

"Lauren Quantrell" <la*************@hotmail.comwrote in message
news:5a**********************************@s13g200 0prd.googlegroups.com...

>>I have an HTML file named myHTML.htm

It looks like this:

<great HTML code>
<more great HTML code>
<even more great HTML code>

<insert HTML here>

</great HTML code>
</more great HTML code>
</even more great HTML code>

I need to use my Access database to pull data from a table and insert
it into the HTML file
where it reads: <insert HTML here>

Doable?

Any help is appreciated,
lq

[Larry Linson]

"Tom van Stiphout" <no*************@cox.netwrote in message
news:3p********************************@4ax.com...

On Fri, 18 Jan 2008 19:44:38 GMT, "Larry Linson"
<bo*****@localhost.notwrote:

You could certainly treat an HTML file as a text file, but you could
do the same with a database file (OK, perhaps as a binary file). The
reason we don't is that there is a better object model available, be
it DAO in the case of an MDB file, or DOM or XML in the case of HTML.

-Tom.

Well, yes you can use the DOM for XML, but Lauren is not needing to
"interpret" the XML, just replace one line with already-prepared XML, so
appeared to me that treating it as a text file is the simplest way to
accomplish her purpose.

Larry