ISAM not installable

[Guly]

Hi,
i' ve the follow problem: the code below generate an exception....

private void btnElabora_Click(object sender, System.EventArgs e)
{

File.Copy(FileName, @"C:\\Paesi\\Paesi.xls", true);

OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
C:\\Excel_Prova.xls;Extended Properties=Excel 8.0;HDR=YES;");
objConn.Open();

OleDbCommand objCmd = new OleDbCommand();
objCmd.Connection = objConn;

objCmd.CommandText = "INSERT INTO [Sheet1$]
IN 'C:\\Excel_Prova.xls' 'Excel 8.0;' SELECT * FROM qry_Paesi_Risult";

objCmd.ExecuteNonQuery();
objConn.Close();
}

The exception is the following:
"Installable ISAM not found."
Help me!

Tia. Guly

--
Bye. Guly

Inviato da www.mynewsgate.net

[bh]

http://www.visual-basic-data-mining....spx?PostID=791

http://www.error-bank.com/microsoft....86_Thread.aspx

"Guly" <93********@mynewsgate.net> wrote in message
news:20***************@mynewsgate.net...

Hi,
i' ve the follow problem: the code below generate an exception....

private void btnElabora_Click(object sender, System.EventArgs e)
{

File.Copy(FileName, @"C:\\Paesi\\Paesi.xls", true);

OleDbConnection objConn = new System.Data.OleDb.OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
C:\\Excel_Prova.xls;Extended Properties=Excel 8.0;HDR=YES;");
objConn.Open();

OleDbCommand objCmd = new OleDbCommand();
objCmd.Connection = objConn;

objCmd.CommandText = "INSERT INTO [Sheet1$]
IN 'C:\\Excel_Prova.xls' 'Excel 8.0;' SELECT * FROM qry_Paesi_Risult";

objCmd.ExecuteNonQuery();
objConn.Close();
}

The exception is the following:
"Installable ISAM not found."
Help me!

Tia. Guly

--
Bye. Guly

Inviato da www.mynewsgate.net