PDA

View Full Version : MySQL database conversion from Excell ??


koolkeath
Sun 6th Jul '03, 4:48pm
I am maintaining a sit that list businesses and several tables of information abou these businesses.

Ideally I would like to maintain the information through excell. Does anyone know of a way to convert excell tables to mysql databases besides writing out the mysql code. Are there convertors available?

thanks.

-jason

merk
Sun 6th Jul '03, 10:35pm
I am maintaining a sit that list businesses and several tables of information abou these businesses.

Ideally I would like to maintain the information through excell. Does anyone know of a way to convert excell tables to mysql databases besides writing out the mysql code. Are there convertors available?

thanks.

-jason

you should be able to save as CVS from excel, and then import the CVS file into phpmyadmin.

Brian Briscoe
Sun 6th Jul '03, 11:38pm
I can possibly write a script to do this... Let me see, Ill try experimenting tonight. If i come up with anything I will let you know.

koolkeath
Mon 7th Jul '03, 7:17am
Thanks for the help everyone.