please help how it is possible to connect Excel 2007 to sharepoint 2007 ?
Current code is:
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:boundfield DataField="F4" HeaderText="F4" SortExpression="F4"></asp:boundfield>
</Columns>
</asp:GridView>
<asp:SqlDataSource runat="server" ID="SqlDataSource1" ProviderName="System.Data.Odbc" ConnectionString="Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};dbq=\\Folder\File.xlsx;defaultdir=\\Folder;driverid=1046;fil=excel 12.0;filedsn=http://sharepoint.co.com/Proba.dsn;maxbuffersize=2048;maxscanrows=10;pagetimeout=5;readonly=1;safetransactions=0;threads=3;uid=admin;usercommitsync=Yes" SelectCommand="SELECT `'Consolidated List$'`.F4
FROM `'List$'` `'List$'`
WHERE (`'List$'`.F10='SomeName') AND (`'List$'`.F57 Not Like '%Completed%')">
</asp:SqlDataSource>
In SPD, it returns the grid without error.
However, opening the page, error message received: The control cannot find the SqlDataSource1
ERROR [IM002] [Microsoft] [ODBC Driver Manager] Data source name not found and no default drive specified
Description: An unhandled exception occured during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
