Buat aja script PHP sederhana yg mem-parsing isi file text tersebut ke dalam array. Lalu di INSERT ke database.
--- "[EMAIL PROTECTED] malinux" <[EMAIL PROTECTED]> wrote: > pagi.. > pagi2 nanya.. :-) > > saya ngimport data txt (asalnya xls) ke table mysql > kok error ya? > dengan phpmyadmin dibilang: > SQL-query : > LOAD DATA LOCAL INFILE > 'C:\\DOCUME~1\\ADMINI~1\\LOCALS~1\\Temp\\phpAF.tmp' > INTO TABLE `clients` FIELDS TERMINATED BY ';' > ENCLOSED BY '"' > ESCAPED BY '\\' LINES TERMINATED BY '\r\n' > MySQL said: > The used command is not allowed with this MySQL > version > pake command line, dia bilang gini: > Error 1148: The used command is not allowed with > this MySQL version > coba dengan mysqlfront, samma: > The used command is not allowed with this MySQL > version > knapa ya'? > saya punya buanyak data nee.. masa diimput lagi > atu2..?? > > trims ka > imam > __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Berhenti langganang: [EMAIL PROTECTED] Arsip dan info: http://linux.or.id/milis.php
