Delete a table in MA Access

sonmic
sonmic used Ask the Experts™
on
Hi,

How can i delete a table in a MS Access 2003 DB from SAS? And first check if the table exists?

Tx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Marketing Consultant
Commented:
Use a libref with the Access engine and proc sql.

   libname msaccess access '<path and filename.mdb'> <options like user id and password if needed>;

proc sql;
  drop table msaccess.tableName;
quit;

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial