Desktop productivity for business analysts and programmers

How to export to ACCESS using EG 5.1

Reply
New Contributor
Posts: 3

How to export to ACCESS using EG 5.1


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

Super User
Posts: 5,386

Re: How to export to ACCESS using EG 5.1

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

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 996 views
  • 0 likes
  • 2 in conversation