Using Excel as Datasource -- sql server reporting services

Sudha
2/17/2005 2:39:01 PM

Hi,

I did the following :
From Data Link Properties dialog Provider tab, choose Microsoft Jet
4.0 OLE DB Provider.
In the Connection tab
Typed the name of the workbook into the 'Select or enter a database
name' box (or select it by clicking the 'ellipses' button, changing
the 'File of Type' dropdown to 'All Files (*.*)' and navigating the
workbook and clicking OK).
On the 'All' tab, select 'Extended Properties' in the list and click
'Edit value'.
Enter the value Excel 8.0 (Excel<space>8<dot><zero>).
On the Connection tab, click the 'Test Connection' button.

Connection succeded

Exit the Data Link Properties dialog.

When I exit datalink it says
"Connection cannot be made to the database
set and test the connecting string.Unrecognised datbase format filenale.xls"

I notice that the extended properties value which I set to Excel 8.0 is no
longer available.

What am I doing wrong.Pls help.it is urgent.

Thank You,
Sudha

Brian Welcker [MSFT]
2/21/2005 10:26:29 AM

Did you try specifying the properties in the connection string directly? You
should be able to add:

Extended Properties=Excel 8.0;HDR=YES;

To your connection string.

--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

sql server reporting services : Using Excel as Datasource