> I have a few hundred rows of data to import into a mysql db. Its currently > tab separated. > > What's the most straight forward way (ie i dont want to enter it line by > line) of doing a bulk import? > > I have full admin rights to my dev server. Is there a method or software app > that people can recommend to me.
If the columns match your database exactly, then you can use LOAD DATA INFILE command. If not, then you can write a PHP script to read each line and format it into an INSERT query. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php