How can I export text data from FrontPage html page to Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
==============================================
 
Back
Top