Jun 16, 2003 #1 dpdoug Programmer Nov 27, 2002 455 US We're going to receive a spreadsheet with a product list and prices of about 1000 items that we need to insert into a mysql table. What's the best way to do this? David
We're going to receive a spreadsheet with a product list and prices of about 1000 items that we need to insert into a mysql table. What's the best way to do this? David
Jun 16, 2003 #2 QatQat IS-IT--Management Nov 16, 2001 1,031 IT 1) Use a GUI with import capabilities like SQLyog http://www.sqlyog.com 2) Export the spreadsheet into a text file with field delimiter and re-import it into a table with same structure in mysql. Bye Qatqat Life is what happens when you are making other plans. Upvote 0 Downvote
1) Use a GUI with import capabilities like SQLyog http://www.sqlyog.com 2) Export the spreadsheet into a text file with field delimiter and re-import it into a table with same structure in mysql. Bye Qatqat Life is what happens when you are making other plans.