* Inandjo Taurel > i'd like to have the syntax to import in a mysql table from a tab > delimited text file, and also the same thing from an excel file.
See the LOAD DATA statement and the mysqlimport utility: <URL: http://www.mysql.com/doc/en/LOAD_DATA.html > <URL: http://www.mysql.com/doc/en/mysqlimport.html > Regarding Excel, I think the easiest approach is to export from Excel to csv format (or similar), and then use one of the above methods to load it into mysql. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php