Posted by Tom on 04/25/07 20:58

On Wed, 25 Apr 2007 09:19:15 +0100, Blagovist wrote...
>
>Hi.
>Is there an easy way to "lift" data from HTML tables and enter that into
>my database? I'm a total novice and so far my searches have yielded
>little. I see Navicat has an import option, but that appears to be for
>well structured data like Word, Excel or PDF...
>
>Thanks,
>
>Blago

There's usually extra HTML tags between the ones used for your table, so it's
not very easy. With PHP you can probably open a file, look for a pattern
(regex), and pull the information out that way.

If I'm in a rush, maybe copy from the web browser and paste into Notepad. That
usually clears out the formatting controls, but not very automated.

Tom
--
Newsguy.com - Basic Accounts $39.95 / 12 months

[Back to original message]