I can import data from Excel using the following code if the spreadsheet is saved on the computer and has a non-empty path name:

string connStr = "Provider=Micro soft.Jet.OLEDB. 4.0; Data Source=" + oXL.ActiveWorkb ook.Path + "\\" + oXL.ActiveWorkb ook.Name + ";" + "Extended Properties=Exce l 8.0";

OleDbCommand cmdSelect = new OleDbCommand("S ELECT * FROM [" + oSheet.Name +...