Post reply

Excel to MS SQL 2000 info update

  • February 27, 2006 at 9:51 am

    #67234

    Hi all,

    I have a task at hand requiring me to update several fields for employee records in an SQL 2000 database. I have consolidated all the information needed to update the SQLDB but am kinda new to the SQL thing. I have tried to recreate a similar table consisiting of the same column headers and datatypes for the existing information and used DTS to try and push the information to the DB with little success.

    The colums I am trying to update SQL side are as follows: EmpID (varchar), Name (nvarchar), Title (nvarchar), Department (int)

    I get an error when trying to push this info from a spreadsheet into SQL using the DTS function in Enterprise Manager. For some reason if I push the data into the target table it will create all DataTypes as nvarchar only, data being moved will not inherit the attributes of the Datatypes already defined in the table i created. Please advise.

  • February 28, 2006 at 9:44 am

    #623737

    Hi,

    Just use the 'Transform' button in the DTS to map the columns.

    This ensures that everything goes in correctly

  • February 28, 2006 at 10:41 am

    #623754

    Dood ru serious...? I've already done that! Transform will allow to change constraints and datatypes but will not analyze anything, it will simply let you go through the process and then gives you the error. Please delete this post, I've managed to get the data over, however there are some issues with the constraints on some of the data types.

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

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