how to load sql server table data into excel without getting converted into text

  • Hi all,

    I am facing a problem in loading the sql server table data into excel. I am able to load the data from sql server into excel but the data which is of int datatype in Sql server getting converted into text in excel.

    Please let me know if anyone has any solution for this issue.

    Thanks,

    sai

  • That's one of the things I never liked about excel (the fact that it changes data types). Which is why excel can be bad for creating extracts. Not sure if this will work, but try using the data conversion task for the integers to convert them integers and see if that works.

    Another thing I've noticed with excel also is then the excel document already exists it will change anything that is loaded into it into the data type it is using. If the first doesn't work, try creating the output in a brand new location to see if it correctly created the correct data types.

    Strick

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

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