Re: HTML table to MySQL table conversion
| From: | RNie | Date: | Thu, 27 Sep 2001 12:24:04 +0000 |
| Subject: | Re: HTML table to MySQL table conversion | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-68989@lists.php.net to get a copy of this message | ||
Well I don't have Access, nor Excel, but there is the Freeware Staroffice
that did it for me. Thank's for the tip. I thought of this myself, but your
message encouraged me to try it and it works.
Method I used:
- Open HTML with Staroffice
- Delete irregular header fields
- Select the whole table and copy it
- Open a new spreadsheet
- Paste the table in the spreadsheet
- Save it as a comma delimited file.
- Create a table with for instance phpMyAdmin according to the data in the
HTML table
- import it into this new table with phpMyAdmin's utility called "Insert
textfiles into table" You have to take care here that you put the same field
delimiter as is used in your file.