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?
2007-08-23 10:47:41 · 5 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
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: http://www.it-map.com/html/mydbpal_.html
more info: http://www.it-map.com/MYdbPAL_flier.pdf
_____________________
2007-08-23 11:31:56 · answer #1 · answered by Einstein 5 · 1⤊ 1⤋
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)
2007-08-25 05:07:42 · answer #2 · answered by just "JR" 7 · 0⤊ 0⤋
Hey,
Here I got PHPmyadmin for free http://bitly.com/1no603p
I love it!
good luck.
2014-07-22 07:36:34 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Hi,
To download for free PHPmyadmin you can click here http://j.mp/1no5zGc
It's amazing.
I hope it helps
2014-07-21 12:09:26 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Save your excel file(s) as .csv (comma delimited), then use the MySQL import command to put into the appropriate table(s).
Good luck!
2007-08-23 17:53:40 · answer #5 · answered by Dennis R 5 · 1⤊ 0⤋