Click to See Complete Forum and Search --> : [RESOLVED] Newbie question


Mr. Someone
01-25-2010, 11:24 PM
I got a table that looks something like this:

ID NAME ADDRESS EMAIL

I need transfer the data to another database:

ID FIRSTNAME LASTNAME ADDRESS EMAIL

All names in the first table are in this form: Last name, first name.... There are 1-? first names. The number varies. Names are seperated with spaces. How can I transfer the data?

I feel like I have done that before but I'm not sure and can't remember how.