How to export MS acess to SAS data

[tulip]

Hi, guys:

I run into a problem. I have data in MS acess and would like to convert it to SAS.

First, I tried to use sas import. I requested user name, password, workgroup DB and workgroup DB password. Regarding workgroup file and corresponding password, I have no clue.

Second, I tried to use acess export function. However, I could not find it. Please advise. Your help is greatly appreciated.

Tulip

[Bill]

tulip;

Import code below is what I use to import. Below that is the code I use to export the same file once I've run it through some SAS steps.

PROC IMPORT OUT= WORK.NewOrdFaults
DATATABLE= "NewOrderFaults"
DBMS=ACCESS REPLACE;
DATABASE="\\Moftp\MainFrameFtp\ESADOWN\NewOrderFaults.MDB";
SCANMEMO=YES;
USEDATE=YES;
SCANTIME=NO;
RUN;


PROC EXPORT DATA= WORK.UpDater
OUTTABLE= "NewOrderFaults"
DBMS=ACCESS REPLACE;
DATABASE="\\MOFtp\MainFrameFtp\EsaDown\NewOrderFaults.MDB";
RUN;

[tulip]

Hi, Bill:

Thank you so much for the prompt reply.

Let me try it and keep it posted.

Best, Tulip

[tulip]

Hi, Bill:

I tried it and it worked so well. Again, thanks lot.

Regards, Tulip