Channel 9 has two videos up about Project Gemini And Project Madison. These two videos will give you a good overview what Gemini and Madison are all about. Both videos are available in a variety of formats Introduction to SQL Server Project Madison The SQL Server team is working on a new project code-named “Madison”. […]
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary.
I installed Office 2010 last night and already I am liking it a lot after using it for about 30 minutes. There are some time savers in this release that will come in handy. This will be just a short post and I will only cover Excel 2010 and Word 2010. The first new thing […]
A programmatic example of how to export an HTML file to excel while keeping grid lines visible. This solution does not require the use of a COM object.
PerformancePoint Server To Become PerformancePoint Services In SharePoint Server Microsoft is consolidating the scorecard, dashboard, and analytical capabilities from PerformancePoint Server into SharePoint Server as PerformancePoint Services, making these capabilities available to millions of SharePoint users around the world. See the announcement here: http://blogs.msdn.com/bi/archive/2009/01/23/microsoft-bi-strategy-update.aspx You can also watch a video of the announcement here: http://www.microsoft.com/winme/0901/35195/Guy_Weismantel_BI_Announcement_MBR.asx
Luca Bolognese has released a .NET library that provides the full set of financial functions from Excel. The main goal for the library is compatibility with Excel, by providing the same functions, with the same behavior. Note though that this is not a wrapper over the Excel library; the functions have been re-implemented in managed […]
Create an excel sheet In the first 2 rows put some data, save the excel sheet as testing.xls on the c drive Execute the command below T-SQL1 2 SELECT * FROM OPENROWSET( ‘Microsoft.Jet.OLEDB.4.0’, ‘Excel 8.0;Database=C:testing.xls’,’SELECT * FROM [Sheet1$]’) SELECT * FROM OPENROWSET( ‘Microsoft.Jet.OLEDB.4.0’, ‘Excel 8.0;Database=C:testing.xls’,’SELECT * FROM [Sheet1$]’) You will see 1 row since the […]