Exporting Data into Access

SWolfe — Thu, 20 Apr 2006 12:15:35 GMT

I am attempting to automatically transfer the results of a series of queries into MS Access as tables. The transfer works well except for the 'Replace' option. I get an error stating 'This engine does not support the REPLACE option." I'm using SAS 8.01. Is there a workaround for this issue? I can't delete or rename the Access tables because they are used in further querying.

Re: Exporting Data into Access

deleted_user — Wed, 10 May 2006 13:50:13 GMT

I use the code
+++++++++++
PROC EXPORT DATA = PS_CLASS_TBL
OUTTABLE = "PS_CLASS_TBL"
DBMS = ACCESS REPLACE;
DATABASE = "c:\CRSE_FACULTY_GRADUATE.MDB";
QUIT;
++++++++++
and don't get the replace error. I'm in version 9. Does the MS Access file *.mdb exist prior to the export? I recall getting the 'engine does not support...' error when I used a libname statement instead of proc export.

As in:
Libname faculty access "c:\CRSE_FACULTY_GRADUATE.MDB";

data faculty.ps_class_tbl;
set work.ps_class_tbl
run;

Another thing, are your SAS results in a view or a 'real' dataset? I've gotten mixed results using views instead of datasets.

topic Exporting Data into Access in Microsoft Integration with SAS

Exporting Data into Access

Re: Exporting Data into Access