Here is my code
string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
"Extended Properties=Excel 8.0;";
OleDbConnection dbConn = new OleDbConnection(Conn);
dbConn.Open ();
OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
OleDbDataAdapter Da = new OleDbDataAdapter();
Da.SelectCommand = Cmd;
DataSet Ds = new DataSet();
Da.fill(Ds);
dg.DataSource = Ds.Tables[0];
dbConn.Close ();

Ok, so what is the error?


--
- Nicholas Paldino [.NET/C# MVP]
- (E-Mail Removed)

"freddy" <(E-Mail Removed)> wrote in message
news:26FDCD2A-C2B2-436A-92B6-(E-Mail Removed)...
> Here is my code
> string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
> c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
> "Extended Properties=Excel 8.0;";
> OleDbConnection dbConn = new OleDbConnection(Conn);
> dbConn.Open ();
> OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
> OleDbDataAdapter Da = new OleDbDataAdapter();
> Da.SelectCommand = Cmd;
> DataSet Ds = new DataSet();
> Da.fill(Ds);
> dg.DataSource = Ds.Tables[0];
> dbConn.Close ();

freddy <(E-Mail Removed)> wrote:
> Here is my code
> string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
> c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
> "Extended Properties=Excel 8.0;";
> OleDbConnection dbConn = new OleDbConnection(Conn);
> dbConn.Open ();
> OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
> OleDbDataAdapter Da = new OleDbDataAdapter();
> Da.SelectCommand = Cmd;
> DataSet Ds = new DataSet();
> Da.fill(Ds);
> dg.DataSource = Ds.Tables[0];
> dbConn.Close ();

Okay, now what's the error?

--
Jon Skeet - <(E-Mail Removed)>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

error An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

"Jon Skeet [C# MVP]" wrote:

> freddy <(E-Mail Removed)> wrote:
> > Here is my code
> > string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
> > c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
> > "Extended Properties=Excel 8.0;";
> > OleDbConnection dbConn = new OleDbConnection(Conn);
> > dbConn.Open ();
> > OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
> > OleDbDataAdapter Da = new OleDbDataAdapter();
> > Da.SelectCommand = Cmd;
> > DataSet Ds = new DataSet();
> > Da.fill(Ds);
> > dg.DataSource = Ds.Tables[0];
> > dbConn.Close ();
>
> Okay, now what's the error?
>
> --
> Jon Skeet - <(E-Mail Removed)>
> http://www.pobox.com/~skeet
> If replying to the group, please do not mail me too
>

error --An unhandled exception of type 'System.Data.OleDb.OleDbException'
occurred in system.data.dll

"Nicholas Paldino [.NET/C# MVP]" wrote:

> Ok, so what is the error?
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - (E-Mail Removed)
>
> "freddy" <(E-Mail Removed)> wrote in message
> news:26FDCD2A-C2B2-436A-92B6-(E-Mail Removed)...
> > Here is my code
> > string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
> > c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
> > "Extended Properties=Excel 8.0;";
> > OleDbConnection dbConn = new OleDbConnection(Conn);
> > dbConn.Open ();
> > OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
> > OleDbDataAdapter Da = new OleDbDataAdapter();
> > Da.SelectCommand = Cmd;
> > DataSet Ds = new DataSet();
> > Da.fill(Ds);
> > dg.DataSource = Ds.Tables[0];
> > dbConn.Close ();
>
>
>

Look at this ---
c:\\\\G_Drive_Entitlements_STM_2005.xls;"

Even in C# that would mean C:\\G_Drive_Entit...

If fixing that doesn't help, can we see your XLS? Also I assume that your
error is at Da.Fill .

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik

"freddy" <(E-Mail Removed)> wrote in message
news:26FDCD2A-C2B2-436A-92B6-(E-Mail Removed)...
> Here is my code
> string Conn ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
> c:\\\\G_Drive_Entitlements_STM_2005.xls;" +
> "Extended Properties=Excel 8.0;";
> OleDbConnection dbConn = new OleDbConnection(Conn);
> dbConn.Open ();
> OleDbCommand Cmd = new OleDbCommand("Select * From [Sheet1$]", dbConn);
> OleDbDataAdapter Da = new OleDbDataAdapter();
> Da.SelectCommand = Cmd;
> DataSet Ds = new DataSet();
> Da.fill(Ds);
> dg.DataSource = Ds.Tables[0];
> dbConn.Close ();

freddy <(E-Mail Removed)> wrote:
> error An unhandled exception of type 'System.Data.OleDb.OleDbException'
> occurred in system.data.dll

And what's the message in the exception object?

See http://www.pobox.com/~skeet/csharp/complete.html for a good way of
getting answers to problems quickly, rather than requiring several
rounds of question and answer.

--
Jon Skeet - <(E-Mail Removed)>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

> See http://www.pobox.com/~skeet/csharp/complete.html for a good way of
> getting answers to problems quickly, rather than requiring several
> rounds of question and answer.

<--- Couldn't agree more !!

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik


"Jon Skeet [C# MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> freddy <(E-Mail Removed)> wrote:
> > error An unhandled exception of type 'System.Data.OleDb.OleDbException'
> > occurred in system.data.dll
>
> And what's the message in the exception object?
>
> See http://www.pobox.com/~skeet/csharp/complete.html for a good way of
> getting answers to problems quickly, rather than requiring several
> rounds of question and answer.
>
> --
> Jon Skeet - <(E-Mail Removed)>
> http://www.pobox.com/~skeet
> If replying to the group, please do not mail me too