topic Re: how import data from access 2010 to sas enterprise miner 12.1 in SAS Programming

how import data from access 2010 to sas enterprise miner 12.1

O_Lavrentii — Mon, 19 Jan 2015 15:25:12 GMT

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)

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

O_Lavrentii — Tue, 20 Jan 2015 07:09:18 GMT

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

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

O_Lavrentii — Tue, 20 Jan 2015 07:15:54 GMT

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?

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

mohamed_zaki — Wed, 21 Jan 2015 11:54:25 GMT

Did you make sure that this is the right dir?

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

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

jakarman — Wed, 21 Jan 2015 14:28:34 GMT

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.