R
rsanan
I am importing some data from Excel file into a DataSet
After the import I always get a pop up message saying "upload file is
now available for editing"
retry /cancel
How do i avoid the message?
Follow is a part of the code
/********CODE********/
strCom = " SELECT * FROM [Upload$] ";
string strCon =" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source
="+uploadFile+";Extended Properties=Excel 8.0"; conn.ConnectionString =
strCon;
adapter.SelectCommand = new OleDbCommand(strCom, conn);
conn.Close();
adapter.Fill(tempDS);
/********CODE********/
Thanks in advance
After the import I always get a pop up message saying "upload file is
now available for editing"
retry /cancel
How do i avoid the message?
Follow is a part of the code
/********CODE********/
strCom = " SELECT * FROM [Upload$] ";
string strCon =" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source
="+uploadFile+";Extended Properties=Excel 8.0"; conn.ConnectionString =
strCon;
adapter.SelectCommand = new OleDbCommand(strCom, conn);
conn.Close();
adapter.Fill(tempDS);
/********CODE********/
Thanks in advance