Date:         Fri, 7 Apr 2000 08:47:11 -0700
Reply-To:     Billy Barker <billyNObiSPAM@MSMC.COM.INVALID>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Billy Barker <billyNObiSPAM@MSMC.COM.INVALID>
Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here
Subject:      PROC EXPORT to Append NOT Replace MS ACCESS Table

I am writing SAS code to populate a VB/ACCESS aplication
with data.  PROC EXPORT (DBMS=ACCESS2000 REPLACE) causes
the following error:

ERROR: DAO Error encountered: Cannot delete this index or
table.  It is either the current index or is used in a
relationship.

Is there a way to use PROC EXPORT to append to an existing
MS ACCESS 2000 table?  I couldn't any combination of
keywords which worked.  I am using release 8.00.

Thank you,

Billy Barker
Miami Beach, FL



* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping.  Smart is Beautiful