Post reply

Exporting SQL data through OPENrowset into Excel numeric coming across as text

  • May 10, 2010 at 12:00 pm

    #232486

    Hi everyone,

    I have a stored procedure that gathers data and writes it to an excel file which in turn is emailed out daily. It works great with the exception that all of the data coming across(including my numeric items) are stored as text on the excel file. I need the numeric items to stay numeric. Any ideas? A couple things to note:

    My numeric variables are declared as such on the stored procedure.

    My columns are formatted as a number on the excel file.

    Your help is appreciated!

    Thanks,

    Nic

  • May 21, 2010 at 6:31 am

    #1170771

    When save the formated excel, leave the cursor one the second blank line, which force the imported data into the third line, somehow this will leave the cell format intact.

    That was my experience for the similar case.

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

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