Desktop productivity for business analysts and programmers

PROC IMPORT DBMS=ACCESS

Reply
Regular Contributor
Posts: 151

PROC IMPORT DBMS=ACCESS

Hello EG-users.

I'm new to EG. I used SAS 9.1.3 at my previous job.

I'm trying to import MS Access table but i'm getting an error:

ERROR: DBMS type ACCESS not valid for import.

The code that  i use is below:

proc import table="a403" dbms=access out=a database="\\sasabm01.region.psb.de\uolib\101_24.mdb"; run;

I tried DBMS=ACCESS97, =ACCESS2000, =ACCESS2002 but i get the same error.

Access to PC files is licensed.

What dbms do i have to use in EG 4.3?

Thanks in advance.

Oleg.

Esteemed Advisor
Posts: 7,299

PROC IMPORT DBMS=ACCESS

If you are using a 64bit version you have to use ACCESSCS

Take a look at: http://support.sas.com/kb/33/228.html

Regular Contributor
Posts: 151

PROC IMPORT DBMS=ACCESS

Thank you Art. The server operating system is Windows server 2000 64bit (as i know).

The code below generates an error:

ERROR: Failed to connect to the Server: sasabm01.region.psb.de

proc import dbms=accesscs

out=a replace table='a403'; port=8621; server="sasabm01.region.psb.de"; database='\uolib\101_24.mdb'; run;

What am I doing wrong?

Oleg.

Esteemed Advisor
Posts: 7,299

PROC IMPORT DBMS=ACCESS

Are you using the SAS  PC files server and is the name correctly identified?

Regular Contributor
Posts: 151

PROC IMPORT DBMS=ACCESS

Thanks for your reply.

I will ask system administrator tomorrow about this details.

Oleg.

Regular Contributor
Posts: 151

PROC IMPORT DBMS=ACCESS

What is "SAS PC Files Server"?

Where can i find it?

For Microsoft Access files, you must use the SAS PC Files Server, as shown in these examples:

proc import dbms=accesscs out=sas-data-output-filename replace table='accessmdb-table-name'; port=8621; server="server-name.company.com"; database='\directory\filename.mdb'; run;

proc export data=sashelp.shoes outtable='accessmdb-table-name' dbms=accesscs replace; database='\directory\filename.mdb'; server="server-name.company.com"; port=8621; run;

Esteemed Advisor
Posts: 7,299

PROC IMPORT DBMS=ACCESS

Regular Contributor
Posts: 151

PROC IMPORT DBMS=ACCESS

Thanks for your reply.

There is no SAS PC Files Server at my workstation.

I use EG 4.3

What should i do?

Windows Service

The server can be manually set to run as a Windows service.

To run as a Windows service, select Start [arrow] Control Panel [arrow] Administrative Tools [arrow] Services.

Locate SAS PC Files Server in the Name column. Select Properties.

Ask a Question
Discussion stats
  • 7 replies
  • 6237 views
  • 1 like
  • 2 in conversation