Import

[avatar]

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

                  datatable='tbl_aa_data' replace;

                  database = "P:\SAS_Data\sampleData\Database1.accdb";

                  server="XXXXXX";

                  port = 8621;

got the following error

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.

any suggestions?

Thanks

[Hima]

What is P drive? Is that a shared drive

[Hima]

I found this link out there with the error you have attached.

http://support.microsoft.com/kb/306269

[ChrisHemedinger]

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:

http://blogs.sas.com/content/sasdummy/2007/12/14/using-sas-enterprise-guide-to-read-microsoft-office...

Chris