how import data from access 2010 to sas enterprise miner 12.1

Reply
New Contributor
Posts: 3

how import data from access 2010 to sas enterprise miner 12.1

proc IMPORT out=data

datatable='data'

dbms=access replace;

database='c:\user\database2.accdb';

run;

an error occurred during the execution of this code

I just start my work with SAS and will so appriciate if you could help my to solve this problem)

New Contributor
Posts: 3

Re: how import data from access 2010 to sas enterprise miner 12.1

Posted in reply to O_Lavrentii

ERROR: Unable to open file C:\Users\Database2.accdb. It does not  exist or it is already opened exclusively by another user, or you need permission to view its data.

my win 64

Super Contributor
Posts: 490

Re: how import data from access 2010 to sas enterprise miner 12.1

Posted in reply to O_Lavrentii

Did you make sure that this is the right dir?

Also what is your sas version and is it 32 or 64?

Trusted Advisor
Posts: 3,215

Re: how import data from access 2010 to sas enterprise miner 12.1

Posted in reply to mohamed_zaki

add to that list of questions on the environment.

Client/Server approach or a standalone desktop version.

When Client/Server the version/type of the SAS/Server process and whether access pcfiles is licensed.

I am guessing it is a Windows server based one.

---->-- ja karman --<-----
New Contributor
Posts: 3

Re: how import data from access 2010 to sas enterprise miner 12.1

Posted in reply to O_Lavrentii

ERROR: Unable to open file . It does not  exist or it is already opened exclusively by another user, or you need permission to view its data.

There is some special requirements for access files?

Ask a Question
Discussion stats
  • 4 replies
  • 304 views
  • 1 like
  • 3 in conversation