Jun 16, 2003 #1 dpdoug Programmer Joined Nov 27, 2002 Messages 455 Location 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 Joined Nov 16, 2001 Messages 1,031 Location 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.