Post reply

exporting data from sql table to excel

  • November 17, 2011 at 9:27 am

    #390890

    I am trying to export sql server table data to excel.

    I have a bit column in table. when I use import/wizard and transfer data the bit column data is showing in negative values in excel

    for ex: source data is 1 and destination data is -1

    I believe that Excel stores a boolean default as -1.

    what datatype I need to select in mapping to convert boolean values to integers, and then write them to Excel.

  • November 17, 2011 at 9:37 am

    #1409324

    Probably best to export from a SQL statement instead of directly from the table. Include a case statement that converts the Boolean values into 'True' and 'False'. You can then manipulate them in Excel in any way you want.

    Alternatively, export direct from the table, but add a Derived Column transformation before you put the data into Excel.

    John

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

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