Viewing 15 posts - 16 through 30 (of 41 total)
Guys, For those of you who needs to go beyond Excel 2003 65000 rows or so limit, you can feed a pivot table with SQL server data.
I provide a couple...
August 13, 2008 at 5:47 pm
Samuel Vella (8/13/2008)
If you're using reporting services and users have web access to run reports then reports can easily be integrated into Excel (not sure about Excel 2000) using a...
August 13, 2008 at 10:07 am
This article is getting unprecedented proportions.
How could we have MS SQL engine development database guys participating in the discussion If they are not yet already doing so or watching...
February 6, 2008 at 8:23 pm
TheSQLGuru (2/1/2008)Gone also is BACKUP LOG WITH TRUNCATE_ONLY/NO_LOG, which I actually use fairly regularly.
Too bad, I found this handy to keep a virtual server test database slim.
I do not regret...
February 1, 2008 at 12:37 pm
Jeff Moden (1/31/2008)
Philippe Cand (1/31/2008)
February 1, 2008 at 11:13 am
I will derail this conversation and give it another spin.
Wether or not something is supported by Microsoft does not make it safer.
It is all about probability and bugs.
January 31, 2008 at 7:26 pm
Yep, looks there are uncertainties in this approach.
It is very database engine centric while mind opening. I keep this article in mind as valuable.
I just thought it could be...
January 31, 2008 at 3:36 pm
Jeff, thanks for this article I learn something new.
I was relying on Reporting Service reports, cubes and MDX to do the running total for me. This article shows me a...
January 31, 2008 at 9:30 am
mojo (1/14/2008)Does anyone know the Microsoft.Jet.OLEDB.4.0 engine works with 64-bit SQL 2005 server?
It has a link to another post where more details are discussed. 😉
January 18, 2008 at 1:26 pm
Yes please, give us a link where we can get the full article, full screen shots and a link to download the working sample package.
This really is a great article....
January 10, 2008 at 6:55 pm
Great, It works perfectly.
I just have to put together the mechanism with the variables.
so instead of an URL not supported by JET, use an UNC
In my example I simply...
January 9, 2008 at 5:31 pm
That would be creating on the fly a new Excel in SharePoint doc library with a path similar to this
January 9, 2008 at 12:04 pm
I like this article. Do you think that I could target a SharePoint portal document library?
Also, I would like the possibility to create a VBA module in addition to the...
January 9, 2008 at 11:26 am
My current ugly work around is to use linked servers to execute the procedures on a 32 bit server and then bring the results across to the 64 bit server.
December 13, 2007 at 9:49 am
Rasool Omidakhsh (11/16/2007)
November 16, 2007 at 12:14 pm