Post reply

Transferring data

  • June 5, 2006 at 8:02 pm

    #61776

    Hi,

      I wanted some suggestions about how to migrate data from Access 2000 to SQL 2005. The tables in current access database is all messed up.

    For instance there is a table where a column named 'contact_info' has name, address, state, Zip, all in the same column separated by comma.

      Any sugestions on how to split and transfer the data appropriately to 'address', ' state, zip etc columns in the new normalised table structure?

     

    Thanks

    Shyam

  • June 6, 2006 at 4:22 pm

    #642153

    Shyam,

    Try posting your question in the SQL Server 2005 Administering or General forums.  This one is for submitting suggestions for improving the SQL Server Central website.

    Greg

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply