Hm! As always Mike you make us think in other directions. I will explore this. I can add it sounds like an excellent title from the edge (or my I hope for sample download on you webpage)
Gunnar Ekblad Kontema IT AB H�stholmsv�gen 32 S-131 30 NACKA 070 545 50 38 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: den 11 februari 2005 16:06 To: RBG7-L Mailing List Subject: [RBG7-L] - Re: GATEWAY question 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
