View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.dotnet.languages.csharp,microsoft.public.dotnet.languages.vb
[email protected] rsanan@gmail.com is offline
external usenet poster
 
Posts: 2
Default now available for editing

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