How to export to ACCESS using EG 5.1

EdrickLearnSAS — Fri, 17 Jan 2014 11:14:57 GMT

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

Re: How to export to ACCESS using EG 5.1

LinusH — Fri, 17 Jan 2014 14:06:24 GMT

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)...

topic How to export to ACCESS using EG 5.1 in SAS Enterprise Guide

How to export to ACCESS using EG 5.1

Re: How to export to ACCESS using EG 5.1