homepage Welcome to WebmasterWorld Guest from 54.204.215.209
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
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?
Thank you.

 

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.

Regards...jmcc

joftech




msg:1578478
 4:36 am on Feb 20, 2006 (gmt 0)

You should give Navicat MySql a spin.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved