PROC IMPORT DBMS=ACCESS

[Oleg_L]

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.

[art297]

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

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

[Oleg_L]

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.

[art297]

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

[Oleg_L]

Thanks for your reply.

I will ask system administrator tomorrow about this details.

Oleg.

[Oleg_L]

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;

[art297]

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

[Oleg_L]

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.