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.
... View more