View Single Post
  #2 (permalink)  
Old 04-14-2004, 09:47 AM
ChrisRC ChrisRC is offline
WebProWorld Pro
 
Join Date: Mar 2004
Location: Pittsburgh, PA, USA
Posts: 109
ChrisRC RepRank 0
Default

You can.

First, set up the structure of the table in MySQL.
Then save the Excel file as either comma seperated or tab seperated text file.

In MySQL, go to your table properties
go to the SQL tab
near the bottom of the SQL page is a link to "Insert data from a textfile into table" click that.
You can adjust these settings as needed but your "fields terminated by" will be either , for a csv or \t for a tab delimited file. Lines terminated by should default to \r\n which is correct.

Browse to the location of your file, then hit submit.

Note that these instructions are based on phpMyAdmin 2.5.6-rc1, although I don't think this task has changed much in a few versions.
Reply With Quote