03-22-2012 10:31 AM
I am trying to import a access database in to EG 4.1
the database is saved in a networkdrive .
proc import out= work.tbl_data_data
dbms = Accesscs
database = "P:\SAS_Data\sampleData\Database1.accdb";
port = 8621;
got the following error
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.
03-23-2012 10:37 AM
EG 4.1 (using SAS 9.1) cannot import Microsoft Access 2007/2010 files. I think that's the limitation.
You might be able to use this technique: