Welcome to WebmasterWorld Guest from 188.8.131.52 , register , login , search , subscribe , help , library , PubCon , announcements , recent posts , open posts Subscribe to WebmasterWorld
Excel to Mysql conversion. Trying to move from CMS to my own system. AdamSocial msg:1578474 9:35 pm on Jan 24, 2006 (gmt 0) Hello.
I'm attempting to convert from a lousy CMS to a custom system more suited to my needs.
I was wondering if there were an easy (free) way to convert my data using MS Excel? I've tried exporting my MYSQL data to excel using CSV, adding and renaming the new tables that I need, and importing it into the new database on my test site.
When I've done this, I've gotten errors about line deliminated by ___ .
Anyone able to help?
jatar_k msg:1578475 9:26 pm on Feb 9, 2006 (gmt 0)
data conversion is a very tedious task
are you going from mysql to mysql?
You don't necessarily need to use excel/csv as the go between.
if you could create all of your old tables in your knew database you could use some scripting to convert it as well.
HughMungus msg:1578476 10:16 pm on Feb 9, 2006 (gmt 0)
I've done this a lot. Should be easy. Why not try exporting, importing, and THEN deleting whatever you don't want? jmccormac msg:1578477 4:30 am on Feb 20, 2006 (gmt 0)
What database are you converting/importing from? Do you have the schema for the tables in the old db?
If it is MySQL to MySQL, then it is a lot easier.
joftech msg:1578478 4:36 am on Feb 20, 2006 (gmt 0)
You should give Navicat MySql a spin.