topic PROC IMPORT DBMS=ACCESS in SAS Enterprise Guide

PROC IMPORT DBMS=ACCESS

Oleg_L — Wed, 24 Aug 2011 14:42:53 GMT

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.

PROC IMPORT DBMS=ACCESS

art297 — Wed, 24 Aug 2011 14:49:38 GMT

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

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

PROC IMPORT DBMS=ACCESS

Oleg_L — Wed, 24 Aug 2011 15:25:46 GMT

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.

PROC IMPORT DBMS=ACCESS

art297 — Wed, 24 Aug 2011 15:44:06 GMT

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

PROC IMPORT DBMS=ACCESS

Oleg_L — Wed, 24 Aug 2011 16:05:36 GMT

Thanks for your reply.

I will ask system administrator tomorrow about this details.

Oleg.

PROC IMPORT DBMS=ACCESS

Oleg_L — Wed, 31 Aug 2011 12:19:10 GMT

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;

PROC IMPORT DBMS=ACCESS

art297 — Wed, 31 Aug 2011 12:42:02 GMT

Here is a pointer to the documentation: http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003352567.htm

PROC IMPORT DBMS=ACCESS

Oleg_L — Wed, 31 Aug 2011 15:31:18 GMT

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 Control Panel Administrative Tools Services.

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