What OLE DB providers installed into SQL Server Reporting Services version 2005
Hello Folks, I'm reading Excel file from my C# program and in SQL Server Reporting Services Server version 2008 I can get data using Ole Db JET Provider, using ConnectionString below: Provider=Microsoft.Jet.OLEDB.4.0;Data Source='tester.xls';Mode=ReadWrite;Extended Properties="Excel 8.0;HDR=YES;IMEX=1" But how about in version 2005? I have tried this and couple others but not succeeded. Can anyone tell me what drivers are installed into version 2005 and maybe give some working examples there? Thanks, Michael
November 12th, 2010 8:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics