|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
May 2nd, 2003, 12:44 PM
|
|||
|
|||
|
Importing Excel into MySQL
Heres a brain buster for you guys. I need to get information from an Excell Spreadsheet into a MySQL database. I've gotten it to work to a point but it always falls short. I've saved the file as a Tab Delimited Txt file and then tried to import it into MySQL. All the information goes in correctly, its just not sperating into the correct feilds. If you don't knwo hwo to go from Excell to MySQL what about Access to MySQL? Either way works for me so long as I don't have to put it all in by hand. Thanks guys!
|
|
#2
May 2nd, 2003, 01:42 PM
|
|||
|
|||
|
RE: Importing Excel into MySQL
Save the file as a CSV file (comma seperated values) not as a tab delimited file. How are you importing the file, through the MySQL shell or through a third party tool like PHPMyAdmin.
|
|
#3
May 2nd, 2003, 01:47 PM
|
|||
|
|||
|
RE: Importing Excel into MySQL
You can also export directly from access to a CSV file so that might save you a step. Also make sure the CSV fields are in the same order as the MySQL table Fields.
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Importing Excel into MySQL |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
