Gunnar, I suppose all the various ODBC drivers can be used in the same way as the Excel driver.
I think I gave you this link before, but I will post it here again. This link provides a very thorough resource for connection strings. http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Friday, February 11, 2005 10:46 AM Subject: [RBG7-L] - Re: GATEWAY question 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
