At 02:59 PM 2008-03-09, you wrote: >I'm upgrading a client from a (very) previous version of a CMS that >I've written to a newer version. I want to transfer their data over, >but the table structures are slightly different. The tables and >fields are essentially the same but have variation in naming schemes. Interesting how things work. Yesterday I got some books out of storage thinking "This might come in handy". Lo and behold, Joe Selko's "SQL for Smarties: Advanced SQL Programming" Gave me the answer. And it's dead stupid simple (my favourite kind of answer). All one needs is one query per table. INSERT INTO new_table ( ArticleID , ArticleTitle , ArticleBody , [... abreviated ...] ) SELECT article_id , article_title , article_body , [... abreviated ...] FROM database_name.old_table Niiice. Frank Marion lists at frankmarion.com Keep the signal high.