Date:         Thu, 17 Feb 2000 11:19:55 +0000
Reply-To:     Ahmed.AL-ATTAR.-.Sun.ENTERPRISE.SERVICES.INFORMATION.RESOURCES.DATA@CRONKITE.CC.UGA.EDU
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ahmed.AL-ATTAR.-.Sun.ENTERPRISE.SERVICES.INFORMATION.RESOURCES.DATA@CRONKITE.CC.UGA.EDU
Organization: Sun Microsystems
Subject:      Re: Writing data to MS Access (v2)
Content-Type: text/plain; charset=us-ascii

Gavin Albury wrote:
>
> Has anyone got any examples/code to write directly to MS Access from within a SAS data step ??
>
> The SAS site seems to intimate that this is possible via DDE commands, but doesn't detail how, and the DDE help file I have deals
> more with DDE commands being used to access Excel.
>
> I already have notes (from the SAS website) on how to do this using the import/export commands on the menu bar of both applications.
>
> Any help much appreciated.
>
> Gavin Albury
> SAS Programmer

How about using Sql Pass-Through for ODBC ?

Within Proc sql, you can use the execute statement to update your MS
Access tables.
Check the online help for examples.

Ahmed