importing tables
| From: | Johannes Janson | Date: | Fri, 03 Nov 2000 15:09:37 +0000 |
| Subject: | importing tables | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4188@lists.php.net to get a copy of this message | ||
Hi,
I want to create a database containing informations about lectures
at my university (room, time, prof etc.). The information is avaliable
in HTML and as an Excel-file. Hoe can I improt this to MySQL ?
Do I have to make an Acess-DB out of it to import it.
When loading it via LOAD DATA INFILE file.txt the information is screwed up.
By the way: how can I display the "warnings" about which MySQL informs
me after the query ? I tried this by "ERRORS TO err_table" but it didn't
work.
Thanks in advance.