Sorry, out of my depth here. Maybe the file name would work? (Q - Would a
DB driver that works with XL97+ files work with older Excel file formats?)

--
Jim
wrote in message
oups.com...
| Any idea on how I could access a sheet in Excel 2.1 using OLEDB?
|
| Most queries look like this with more recent version of excel:
|
| SELECT * FROM [Sheet Name$]
|
| What happens when there are no sheets as in the case of older excel
| versions?
|