Importing Access file

[Shyamkumar]

Hi All,

Client given Access file to import in the SAS,
I unable to import the data. Kindly help out me, as it is new to me.

[ballardw]

What code have you tried so far?

"unable to import the data" is awful vague.

Are there errors in the log?: Post the code and log in a code box opened with the {i} to maintain formatting of error messages.

No output? Post any log in a code box.

Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

[Shmuel]

Searching google for: sas support how to import access database example

listed a great list of result. One of them in this link.

[Ksharp]

If you has old access file .try libname statement: libname x 'c:\temp\xxx.mdb'; libname x access 'c:\temp\xxx.mdb'; If you have 2007 version access . try proc import: proc import database='c:\temp\xxxx.acce' datatable='yyyy' out=have dbms=access replace; run;

[Ksharp]

If you has old access file .try libname statement: libname x 'c:\temp\xxx.mdb'; libname x access 'c:\temp\xxx.mdb'; If you have 2007 version access . try proc import: proc import database='c:\temp\xxxx.acce' datatable='yyyy' out=have dbms=access replace; run;