Importing records from HTML files

[xormngr]

Task:

Parse HTML tables and put each row into a FM row (record).

Details:

I have been given about 2 dozen team rosters in html format and I need to parse the data and import into a FileMaker database (v5 or 6

[andygaunt]

Here is a way to go about this.

If on a pc, right click on the HTML page and export to microsoft excel.

Then you can remove the columns you do not want, save as an Excel document and import into FileMaker Pro.

You may be able to do this with an XSLT stylesheet only if using FileMaker Pro 6 though.

HTH