Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing from a Spreadsheet

Status
Not open for further replies.

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
 
1) Use a GUI with import capabilities like SQLyog



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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top