Exporting to Excel Using a CLR Stored Procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Anders Pedersen » Exporting to Excel Using a CLR Stored...

122 posts, Page 2 of 13

««1 2 3 4 5 »»»

Exporting to Excel Using a CLR Stored Procedure

Rate Topic

Display Mode

Topic Options

Author

Message

ashutosh.pathak

Posted Wednesday, December 02, 2009 2:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 09, 2009 9:17 PM
Points: 4, Visits: 6

Where is source code!!!!!!!!!!!!!!!!!

Post #827274

bharathsivam

Posted Wednesday, December 02, 2009 3:13 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, December 02, 2009 10:43 PM
Points: 12, Visits: 26

Attachment (ExcelExport.dll) is missing.

Post #827287

Rob Fisk

Posted Wednesday, December 02, 2009 3:21 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, June 29, 2012 4:56 AM
Points: 163, Visits: 427

Calm down everyone. Source has already been asked for repeatedly. Give it time.

Thanks for opening this alternative avenue.
It looks as if it could be a bit more flexible than the OPENROWSET and BCP examples if used within a SP for creation of a new sheet. I'm assuming it will have similar problems if called from an application in that the path will be local to the SQL server (thinking within a network, not over the internet of course).

Though if it was a web based application then that could be used to retrieve the sheet easily enough.

_______________________________________________________
Change is inevitable... Except from a vending machine.

Post #827290

alber-1003707

Posted Wednesday, December 02, 2009 3:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 22, 2013 2:09 AM
Points: 4, Visits: 18

Looking forward to test it. Exactly what I need

http://www.xodox.ch - LCD vs Plasma

Post #827292

h 47762

Posted Wednesday, December 02, 2009 4:03 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, March 05, 2010 2:49 AM
Points: 10, Visits: 3

Nice, but where is the .... ?

Post #827304

steve quinn

Posted Wednesday, December 02, 2009 4:39 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 7:40 AM
Points: 8, Visits: 58

Interesting.
But source code/DLL please?

Post #827324

ESL_HSBC

Posted Wednesday, December 02, 2009 4:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, September 24, 2012 6:15 AM
Points: 8, Visits: 148

very good but, can't use with SQL2005.... Wink

Post #827325

richard-592555

Posted Wednesday, December 02, 2009 4:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 5:15 AM
Points: 1, Visits: 19

I love it - I think. Where is the download? Smile

Post #827326

The_African010

Posted Wednesday, December 02, 2009 4:53 AM

Valued Member

Group: General Forum Members
Last Login: Friday, October 19, 2012 4:32 AM
Points: 59, Visits: 22

Hi,

What kind of running times are we looking at? Say 1000 rows over 10 workbooks?
Obviously different kit will give different results but say just an average time.

Thanks

Post #827327

napa3uT

Posted Wednesday, December 02, 2009 5:01 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, July 22, 2012 12:47 AM
Points: 10, Visits: 24

Hi,

2 questions:
1. Will it work on SQL 2005?
2. Will I need to install Excel or other Office components on SQL Server machine?

Thanks,
Evgeny.

Post #827332

« Prev Topic | Next Topic »

122 posts, Page 2 of 13

««1 2 3 4 5 »»»

Permissions