I have several thousand html pages that contain text data. I wish to take
that data and have it in fields within an Excel spreadsheet that will
eventually be used to populate a database. The data looks something like this
(all pages are same format)

Heading
Information1 - Information2
Information1 - Information2
3 more lines, same thing

Heading
Information1 - Information2
etc.

I want to be able to have Heading, Information1, Information2 in 3 rows in
Excel.

Can anyone suggest a way to do this other than copy&paste line by line
through several thousand html pages?

You have to cut and paste or may be learn to write a VBA app the will somewhat automate the process.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Paul" <(E-Mail Removed)> wrote in message
news:0B33367E-17AA-4D17-B344-(E-Mail Removed)...
>I have several thousand html pages that contain text data. I wish to take
> that data and have it in fields within an Excel spreadsheet that will
> eventually be used to populate a database. The data looks something like this
> (all pages are same format)
>
> Heading
> Information1 - Information2
> Information1 - Information2
> 3 more lines, same thing
>
> Heading
> Information1 - Information2
> etc.
>
> I want to be able to have Heading, Information1, Information2 in 3 rows in
> Excel.
>
> Can anyone suggest a way to do this other than copy&paste line by line
> through several thousand html pages?

Datatagger

http://www.jafsoft.com/doco/docindex.html

...PC
Paul wrote:

> I have several thousand html pages that contain text data. I wish to take
> that data and have it in fields within an Excel spreadsheet that will
> eventually be used to populate a database. The data looks something like this
> (all pages are same format)
>
> Heading
> Information1 - Information2
> Information1 - Information2
> 3 more lines, same thing
>
> Heading
> Information1 - Information2
> etc.
>
> I want to be able to have Heading, Information1, Information2 in 3 rows in
> Excel.
>
> Can anyone suggest a way to do this other than copy&paste line by line
> through several thousand html pages?