Post reply

DTS Package Adding Apostrophe

  • April 13, 2006 at 2:30 pm

    #67413

    Hello all,

    I'm using a DTS package to transfer some data from an excel spreadsheet to a table in the SQL Server database; then, transferring certain info. out of the database into a differet excel spreadsheet.  For some reason, apostrophes are being added to certain numeric fields on the resulting spreadsheet.  Does anyone know why this happens and what needs to be done to rectify the problem?  Thanks!

    Kindest Regards,

    VL

  • April 13, 2006 at 5:58 pm

    #632548

    Do those columns also contain text other than numeric or is the originating table definition something other than numeric. If either is the case it will define the column as text and thus the number get's an apostrophe in front of it.

  • April 14, 2006 at 8:05 am

    #632622

    Thanks for the info.  It was the fact that the originating table definition had a columntype of varchar(50) for the field, which by the way contains only numeric data; so, just as you said, when I changed the datatype to int, the apostrophe went away. 

    Kindest Regards,

    VL

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

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