|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
|
|
#1
June 19th, 2000, 02:37 PM
|
|||
|
|||
|
I have an excel spread sheet with a lot of information on it and i would like to export it to MySql and so i can post it on the net and make it searchable. Can anyone one help of piont me in the right direction. Thank you
|
|
#2
June 19th, 2000, 05:00 PM
|
|||
|
|||
|
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.)
|
|
| Viewing: Dev Shed Forums > Databases > MySQL Help > Exporting Excel spread Sheet to MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
