there is a program that is called mySQL Front it has a fucntion to import CSV (comma delimited) files into a DB. Just google for it.
HTH Angelo -----Original Message----- From: Freedomware [mailto:[EMAIL PROTECTED] Sent: Friday, January 23, 2004 2:42 PM To: [EMAIL PROTECTED] Subject: [PHP] Importing Text into Database - Can you recommend a tutorial? I'm wading through some of the MySQL literature (whew!), but I'm looking for the quickest way to create some tables and get them online. I just downloaded a software program called EMS MySQL Manager, which appears to work well with phpMyAdmin and makes some functions even easier. Especially useful is a function that imports text from another file, such as a spreadsheet. I haven't been able to finish an import yet, because I'm still learning how to make the tables to import it into; all of my tables have errors of one kind or another. I just wondered if anyone on this list is aware of a particularly helpful tutorial or strategy for doing this sort of thing - or do you just have to wade through all the tutorials and construct your tables, one row/column/function at a time? I have a number of spreadsheet databases, and I'm just looking for the quickest way to get them into a MySQL/PHP database. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php