Post reply

excel destination format

  • April 14, 2015 at 8:39 am

    #398322

    hi

    i have table as below in my SSMS:

    create table tableA

    (ID char(16),

    number int,

    name char(50),

    paydate datetime,

    Amount1 money,

    Amount2 money)

    i am taking data from this table and loading into excel destination.

    which has table like this

    CREATE TABLE `Excel Destination` (

    `ID` LongText,

    `Number`Long,

    `Name` LongText,

    `PayDate` Date,

    `Amount1` currency,

    `Amount2` currency)

    my prob is when i open excel sheet, there is $ sign coming in Amount1 and Amount2 ,how to remove it.

    Also some of the column i am seeing #### ,how to fix it.

    thanks

  • April 14, 2015 at 9:12 am

    #1790850

    For the columns that show "####", have you tried expanding the column width in the worksheet?

    As for the $ sign - you have set the Amount columns to be currency, that's probably why. If you don't want them with a $ sign export them as something else.

    I'm on LinkedIn

  • April 14, 2015 at 9:30 am

    #1790857

    so what data type i should give so that it wont come as $ in my excel sheet

  • April 14, 2015 at 9:37 am

    #1790863

    coool_sweet (4/14/2015)

    so what data type i should give so that it wont come as $ in my excel sheet

    Anything other than currency if you want to avoid the dollar sign. If you still need to use it as a number (for calculations and such) then export it as a generic number. If it doesn't matter, then text.

    Read this and you will find a whole list of options: https://msdn.microsoft.com/en-us/library/ms137643.aspx

    I'm on LinkedIn

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

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