
June 19th, 2000, 05:00 PM
|
|
Junior Member
|
|
Join Date: Jan 2000
Posts: 20
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Export your spreadsheet as a text file. (I tend to use tab-delimited, since sometimes data may have quotes, apostrophes, or commas.) View the text file with a text editor first to make sure it exported the way you expected. Then, use the LOADDATAINFILE command to load your data into the MySQL table. (Make sure that your end-of-line characters are either unix or that you correct for it when you use the LOADDATAINFILE command.)
|