I currently have a process that allows the user to upload an excel spreadsheet. The page queries the file, and uploads to the database. Currently, I am telling the users to verify that the sheet name matches the file name, then querying like:
The problem is that I can't always count on this to happen...
What I direly need is a way to get the sheetname dynamically when the file is uploaded or a suggestion about how to go about tackling this issue.
Any help is appreciated.
Thanks,
gordon
Code:
Set objExcelRS = objExcelConn.Execute("Select * From [" & Mid(OriginalFileName, 1, Len(OriginalFileName) - 4) & "$]")The problem is that I can't always count on this to happen...
What I direly need is a way to get the sheetname dynamically when the file is uploaded or a suggestion about how to go about tackling this issue.
Any help is appreciated.
Thanks,
gordon