Having an issue. I need to be able to read an excel file from a file upload control but I can not save the file to disk first, it must be done in memory.string excelConnectionstring = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
excelConnectionstring += filePath.Replace("/", "\\");
excelConnectionstring += ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'";
OleDbConnection con = new OleDbConnection(excelConnectionstring);
OleDbDataAdapter da = new OleDbDataAdapter();Above is my code for reading the data file if it IS saved to disk, but again, I have to be able to do this without saving the file to disk, it must be done in memory. I have not been able to find any sample code anywhere on how to do this from memory, everything seems to force the file be uploaded, saved to disk, and then read in the connection string, which again I can not do.Any advise would be great, thanks in advance. I'm really in a bind here.
View Complete Post