SQL 2 Excel

Source code checked in, #34165

JoshRoss — Mon, 28 Sep 2009 18:20:51 GMT

Linked the sqltext to the worksheet.

Reviewed: September 2009 Build (Sep 23, 2009)

mjjohnst — Wed, 23 Sep 2009 23:14:01 GMT

Rated 5 Stars (out of 5) - Yes, this looks intriguing - definitely going to take it for a spin.

Reviewed: September 2009 Build (Sep 22, 2009)

meysam_pro — Wed, 23 Sep 2009 05:12:15 GMT

Rated 5 Stars (out of 5) - GoOoOd idea...

New Post: Scripting Performance

joshross — Sun, 20 Sep 2009 14:35:21 GMT

On the next release, I intend on improving the performance of the copy script functionality. I think that this can be done by grabbing the selection and using it as an array, avoiding the performance hit of the application events that are fired when a cell is examined. Finding better algorithms would be a good idea, most of what I have implemented uses brute force techniques. I detest blocking the UI thread during script creating, although it will take a lot of work to marshal the content around to prevent the blocking.

Other features that I have contemplated include, color coded syntax for the input box and rudimentary auto-help for tool-tiping parameters on functions and procedures.

Updated Wiki: Home

JoshRoss — Fri, 18 Sep 2009 20:48:03 GMT

This is an Excel 2007 add-in that I created in order to expedite getting data from SQL queries into Excel.

It also can script a table from a selection.

Updated Wiki: Home

JoshRoss — Fri, 18 Sep 2009 20:31:55 GMT

This is an Excel 2007 add-in that I created in order to expedite getting data from SQL queries into Excel. It also can script a table from a selection.

Created Release: September 2009 Build (Sep 18, 2009)

joshross — Fri, 18 Sep 2009 20:27:22 GMT

This build seems to be stable. Please let me know if you have any issues.

Released: September 2009 Build (Sep 18, 2009)

Fri, 18 Sep 2009 20:27:22 GMT

This build seems to be stable. Please let me know if you have any issues.

Source code checked in, #33808

JoshRoss — Fri, 18 Sep 2009 15:37:23 GMT

Source code checked in, #33807

JoshRoss — Fri, 18 Sep 2009 15:34:57 GMT

Added suggestion to allow for VSTO function integration.

Source code checked in, #33804

JoshRoss — Fri, 18 Sep 2009 15:05:06 GMT

Removed dirt under rug.

Source code checked in, #29369

JoshRoss — Fri, 17 Jul 2009 15:05:11 GMT

Added Tool Tip for sql connection. Fixed anchor on button.

Source code checked in, #29367

JoshRoss — Fri, 17 Jul 2009 14:52:20 GMT

Source code checked in, #29365

JoshRoss — Fri, 17 Jul 2009 14:40:15 GMT

Added buton to change server. Added exception handling.

Source code checked in, #27923

JoshRoss — Fri, 10 Jul 2009 15:22:23 GMT

Updated Release: The output of publish (Jul 09, 2009)

joshross — Fri, 10 Jul 2009 15:15:19 GMT