If your SpreadSheet has Named Ranges, you can use DSN-Less Connection Like:

sconnect ';Driver={Microsoft Excel Driver
(*.xls)};DriverId=790;Dbq=F:\Rb7\Autorent\TvSched.xls;DefaultDir=F:\Rb7\Autoren
t;'

Then:

Sattach MyNamedRange

Bro * fro MyNamedRange

or

Select * fro MyNamedRange

Reply via email to