topic [Urgent] Problem importing a table from access in Microsoft Integration with SAS

[Urgent] Problem importing a table from access

Florent — Fri, 03 Aug 2007 08:16:35 GMT

Hello,

When I try to import a table from access in a sas program, I always receive the same error message. Could you help me to fix it ?

Here is the LOG :

20 /**********************/
21 /* Import access data */
22 /**********************/
23 %let
23 ! mdba_data_tariffs= .....EAGLE.MDB;
24
28 Proc import out=WORK.T_Campaigns
29 datatable="T_Campaigns"
30 dbms=access replace;
ERROR: DBMS type ACCESS not valid for import.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds

31 database="&mdba_data_tariffs";
32 run;
33

P.S : on a local pc it does work but there on the server it doesn't.

Thanks in advance,
Florent

Re: [Urgent] Problem importing a table from access

Cynthia_sas — Fri, 03 Aug 2007 15:29:42 GMT

Hi,
This is probably a question for Tech Support. If you check Tech Support notes for that (or similar) error message, you find
http://support.sas.com/techsup/unotes/SN/006/006976.html
almost the same message for PROC EXPORT because SAS/Access to PC File Formats is not licensed on the server machine (where EG is executing the code).

Your site may have licensed SAS/Access for PC File Formats (PCFF) on the local machine but it is possible that the SAS/Access package was not installed on your server or installed on the server where you need it. For more help with this problem, you should contact Tech Support to see whether the note above also applies to PROC IMPORT as well as PROC EXPORT.

cynthia

Re: [Urgent] Problem importing a table from access

Florent — Mon, 06 Aug 2007 07:38:54 GMT

Thank you for your answer.

After a small check with the server's team, the SAS/Access is not licensed on the server so it's not a problem linked to my program.

I just have to wait they purchase the license and install the component 🙂

Thank you again,

Florent