Openrowset SQL to Excel

SQLServerCentral is supported by Red Gate Software Ltd.

Home Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Openrowset SQL to Excel

Openrowset SQL to Excel

Rate Topic

Display Mode

Topic Options

Author

Message

negoropo

Posted Friday, July 03, 2009 4:09 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 06, 2009 9:10 AM
Points: 4, Visits: 18

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

Post #747125

bitbucket-25253

Posted Friday, July 03, 2009 7:02 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 9:31 AM
Points: 1,555, Visits: 4,556

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.

Before posting a question please read
Before posting a performance problem please read

Post #747135

« Prev Topic | Next Topic »

Permissions