Date:         Tue, 22 Jun 1999 13:53:51 PDT
Reply-To:     Nigel Tufnel <dousk8@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nigel Tufnel <dousk8@HOTMAIL.COM>
Subject:      ODBC Connection to Excel
Comments: To: SAS-L@UGA.CC.UGA.EDU
Content-Type: text/plain; format=flowed

How can I specify a particular Excel workbook when connecting via odbc?
Do I have to set up a new Excel DSN for every workbook that I want to read,
or can I use a "Generic" Excel DSN (not pointing to a specific workbook) and
specify the workbook in the connection string?

e.g.

    libname xlodbc odbc noprompt=";;dsn=excel97;";

the above libname statement does not have enough information .  I want to
point to  c:\excel\myworkbook.xls

Any help here is appreciated

Thanks!
Nigel


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com