title: What would be a valid OleDbConnection ConnectionString for an uploaded file?
body: <p>I am certain I have missed something obvious.</p>
  
  <p>A simple task is before me:  'Upload an Excel (2003) file via ASP.NET on a Forms page and push the contents of that file to a DataTable in preparation for data- validation / storage'.</p>
  
  <p>Those operations work fine already when applied to a locally stored edition of the file -- for that I simply utilize the <strong>OleDbConnection-ConnectionString</strong> "String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0;", fileName)" from an <strong>OleDbDataAdapter</strong>.</p>
  
  <p>However, trying to repeat that with an uploaded edition of the very same file (via a FileUpload control), on the line where I fill the <strong>OleDbDataAdapter</strong> I receive the error [<em>"The Microsoft Jet database engine could not find the object "Sheet1$".  Make sure the object exists and that you spell its name and the path name correctly."</em>]  An error so generic and painful -- still I'm unsure where to look next.  I am guessing the connection-string structure is illegitimate for an uploaded file.</p>
  
  <p>I searched through StackOverflow and MSDN and even around the web with no success thus far, but the search terms may be overly ubiquitous.  Am I required to actually find a local repository for saving the uploaded file to prior to attempting a parse of it's content?  Can I not simply construct a connection to a 'file in memory'?  In case it concerns the answer, the uploaded files are not anticipated to ever exceed 200 kb in size.</p>
  
  <p><strong>Sincere thanks in advance for any assistance provided...</strong></p>