How to export to ACCESS using EG 5.1

[EdrickLearnSAS]

Hi,

My office just migrate from SAS BASE 9.1 to SAS EG 5.1(32bit) and it seems EG 5.1 can't export to access.

Code :

Proc Export data = Temp.Account_2013

          outtable = "Account Data"

          dbms = access

          replace;

     database = "/sasserver/data/temp/Account_Data.mdb";

run;

it shows error : DBMS type ACCESS not valid for export.

anyone can help?

Thanks & Regards

Edrick

[LinusH]

PROC EXPORT is not a core functionality of EG, so it's more important to know about the SAS server that your EG code is executed on. SAS Version, operating system, "bit", SAS license (SAS/ACCESS to PC File Formats)...