Post reply

Openrowset SQL to Excel

  • July 3, 2009 at 4:09 pm

    #132473

    Hi,

    i'm having a problem when i try to use the openrowset to export data from the SQL Server 2005 to Excel.

    For example, the data is being exported to excel, but the data in SQL that is numeric data is being captured as text in Excel. Is there a solution, for this, i would like to capture the numeric data as numbers in excel.

    Thank you

  • July 3, 2009 at 7:02 pm

    #1019889

    I believe you might find the code, or something similiar enough to be adapted so that you can format the particular column as mumeric rather than text in this article.

    http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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