Problem with quotes in your connection string Try this connection string, I have tested this in a sample project
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\Yourspreadsheet.xls;Extended Properties= ""Excel 8.0;HDR=YES;"""; On Sun, Sep 20, 2009 at 10:57 PM, thread <[email protected]> wrote: > > hello > i'm trying to build in C#.net an interface that pulling information > from excel file > from some reason the information is not appearing. > this is the code: > <%-- > > <%@ Page Language="C#" %> > <%@ import Namespace="System.Data" %> > <%@ import Namespace="System.Data.OleDb" %> > <script runat="server"> > > void Page_Load(object sender, EventArgs e) > { > MessageBox.Show("Yaniv"); > string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; > Data Source=C:\Yourspreadsheet.xls; Extended Properties=""Excel > 8.0;HDR=Yes"";"; > string CommandText = "select * from [book$]"; > > OleDbConnection myConnection = new OleDbConnection > (ConnectionString); > OleDbCommand myCommand = new OleDbCommand(CommandText, > myConnection); > > myConnection.Open(); > DataGrid1.DataSource = myCommand.ExecuteReader > (CommandBehavior.CloseConnection); > DataGrid1.DataBind(); > myConnection.Close(); > } > > </script> > <html> > <head> > </head> > <body style="FONT-FAMILY: arial"> > <h2>Simple Data Report > </h2> > <hr size="10" /> > <form runat="server"> > <asp:datagrid id="DataGrid1" runat="server" > EnableViewState="False" ForeColor="Black" BackColor="White" > CellPadding="3" GridLines="None" CellSpacing="1"> > <HeaderStyle font-bold="True" forecolor="white" > backcolor="#4A3C8C"></HeaderStyle> > <ItemStyle backcolor="#DEDFDE"></ItemStyle> > </asp:datagrid> > <hr size="10" /> > </form> > </body> > </html> > > > > --%> > what is wrong? >
