Check if the access table exists from SAS

[deleted_user]

Hi, Is there a way to check if the table in MS Access 2000 database exists, before creating a new table or inserting/updating the existing table from within SAS. (base v 9.1.3)

thanks

[deleted_user]

If you are accessing the Access database through a library assignment with SAS/Access to PC File Formats, then the tables and table structures should be transparent to the SAS session.

Reading the Dictionary.Tables and Dictionary.Columns SQL views will show you what exists in that library assignment.

Kind regards

David