Date:         Wed, 25 Sep 2002 20:22:07 -0400
Reply-To:     Carlos A Caceres <ckaceres@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Carlos A Caceres <ckaceres@YAHOO.COM>
Subject:      MSACCESS TO SAS VIA SAS/ACCESS TO ODBC

Hi:

I'm using SAS/Access to ODBC in order to get access to a MSAccess database.
The name of one of the tables is "PRESUPUESTO 2002". SAS
recognizes "PRESUPUESTO 2002" as a invalid table name. So I can't print,
query, copy with this table.

Is there any way to get access to this table from SAS/Access to ODBC?

My connection statement is like:

libname mydblib odbc user=testuser password=testpass datasrc=mydatasource;


Did I miss any special option?


Note: Renaming the table in the MSAccess database isn't an option.


Thanks :(


CarlosA