How do I get data from my Excel tables into a MySQL database?
Pop B asked:
I have hundreds of columns of data, each one 9 rows, and I would like to turn each column into a record set in a MySQL database. I have no idea how to do that without typing each one into PHPmyAdmin. Is there some way I could “copy and paste” it into the database?
Comments on How do I get data from my Excel tables into a MySQL database?
September 19, 2008
Dennis R @ 3:10 pm
Save your excel file(s) as .csv (comma delimited), then use the MySQL import command to put into the appropriate table(s).
Good luck!
September 21, 2008
Einstein @ 1:13 am
MYdbPAL - A COMPLETELY FREE EDITION FOR MySQL DEVELOPERS AND ADMINISTRATORS
MYdbPAL for MySQL provides a complete design Studio and ETL Workshop environment for application developers and database administrators. Using MYdbPAL users can achieve rapid database conversions from most modern DBMS types, then continue to use MYdbPAL for ongoing database life-cycle maintenance.
MYdbPAL for MySQL contains the exact same functionality as dbPAL Professional, except that users are restricted to updating MySQL databases only (dbPAL Professional offers update for all supported database platforms in a single product). This special edition product for MySQL users ONLY is now available on an unlimited time License FREE OF ALL CHARGES.
download:
more info:
_____________________
September 23, 2008
just "JR" @ 4:32 am
No, there is no way in the format you have!
First answer is correct in some way: to upload to your DB, you just have to convert it into CSV, and most systems will upload it well.
Unfortunately, you have designed your excel table the wrong way. You need to swap the rows and columns!
One record in MySQL is one ROW of your Excel, never a COLUMN: you are stuck…
I do a lot of uploads from clients from Excel to MySQL, and everytime they have made something wrong.
So I have written a program that reads, corrects and reformat Excel files for upload.
Send me (zipped) your excel file (normal format), and I’ll convert it for you. (FOC)
Regards,
JR
(jrc_skyexpress@yahoo.co.uk)
Comments on How do I get data from my Excel tables into a MySQL database?
Save your excel file(s) as .csv (comma delimited), then use the MySQL import command to put into the appropriate table(s).
Good luck!
MYdbPAL - A COMPLETELY FREE EDITION FOR MySQL DEVELOPERS AND ADMINISTRATORS
MYdbPAL for MySQL provides a complete design Studio and ETL Workshop environment for application developers and database administrators. Using MYdbPAL users can achieve rapid database conversions from most modern DBMS types, then continue to use MYdbPAL for ongoing database life-cycle maintenance.
MYdbPAL for MySQL contains the exact same functionality as dbPAL Professional, except that users are restricted to updating MySQL databases only (dbPAL Professional offers update for all supported database platforms in a single product). This special edition product for MySQL users ONLY is now available on an unlimited time License FREE OF ALL CHARGES.
download:
more info:
_____________________
No, there is no way in the format you have!
First answer is correct in some way: to upload to your DB, you just have to convert it into CSV, and most systems will upload it well.
Unfortunately, you have designed your excel table the wrong way. You need to swap the rows and columns!
One record in MySQL is one ROW of your Excel, never a COLUMN: you are stuck…
I do a lot of uploads from clients from Excel to MySQL, and everytime they have made something wrong.
So I have written a program that reads, corrects and reformat Excel files for upload.
Send me (zipped) your excel file (normal format), and I’ll convert it for you. (FOC)
Regards,
JR
(jrc_skyexpress@yahoo.co.uk)