topic Import in SAS Enterprise Guide

Import

avatar — Thu, 22 Mar 2012 14:31:48 GMT

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 — Thu, 22 Mar 2012 14:43:20 GMT

What is P drive? Is that a shared drive

Hima — Thu, 22 Mar 2012 14:50:08 GMT

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

ChrisHemedinger — Fri, 23 Mar 2012 14:37:00 GMT

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:

Chris