Desktop productivity for business analysts and programmers

Import

Reply
Contributor
Posts: 66

Import

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

Regular Contributor
Posts: 233

Import

What is P drive? Is that a shared drive

Regular Contributor
Posts: 233

Import

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

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

Community Manager
Posts: 2,693

Import

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

Ask a Question
Discussion stats
  • 3 replies
  • 297 views
  • 0 likes
  • 3 in conversation