Operation must use an updateable query... while trying to write toExcel file

  • Thread starter Thread starter DAXU
  • Start date Start date
D

DAXU

Hi,

I already searched old posts, but still confused.
I am a asp.net application and user "everyone" does have write and
read right to the excel file
public static readonly string sConnectionString1 =
"Provider=Microsoft.ACE.OLEDB.12.0;" + "Extended Properties=\"Excel
12.0;HDR=No; IMEX=1\"; Data Source= 1.xlsx";

My code is
DbProviderFactory factory =
DbProviderFactories.GetFactory("System.Data.OleDb");
using (DbConnection conn = factory.CreateConnection())
{
conn.ConnectionString = this.ConnString;

conn.Open();
using (DbCommand command = conn.CreateCommand())
{
command.CommandText = "SELECT * FROM [HP
Calculator APR$E4:E6]";
//reading is ok
using (DbDataReader dr =
command.ExecuteReader())
{
while (dr.Read())
{
string hello = dr[0].ToString();
}
}

//insert fails
command.CommandText="insert into [HP
Calculator APR$] (F1,F2) values ('aadbb','ddeef')";
int i=command.ExecuteNonQuery();

//update fails as well, the exception is:No
value given for one or more required parameters.

StringBuilder sb = new StringBuilder("update [HP
Calculator APR$] set ");
sb.AppendFormat("{0}='{1}'", "G3",
quoteRequest.TotalPrice);

sb.Append(" where E1='0'");
command.CommandText = sb.ToString();
command.ExecuteNonQuery();

}

I am totally confused, can someone help me?

Thanks
 
I'd try on one of the Access newsgroups -- I don't think that many
people are familiar with Ace around here.

--Mary
 
¤ Hi,
¤
¤ I already searched old posts, but still confused.
¤ I am a asp.net application and user "everyone" does have write and
¤ read right to the excel file

You may need to provide full access to the folder where the file is located. I would give that a try
first.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top