topic Re: Check if the access table exists from SAS in Microsoft Integration with SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Check-if-the-access-table-exists-from-SAS/m-p/9138#M328 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.<BR /> <BR /> Reading the Dictionary.Tables and Dictionary.Columns SQL views will show you what exists in that library assignment.<BR /> <BR /> Kind regards<BR /> <BR /> David Mon, 07 Apr 2008 01:17:13 GMT deleted_user 2008-04-07T01:17:13Z Check if the access table exists from SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Check-if-the-access-table-exists-from-SAS/m-p/9137#M327 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)<BR /> <BR /> thanks Fri, 04 Apr 2008 14:44:38 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Check-if-the-access-table-exists-from-SAS/m-p/9137#M327 deleted_user 2008-04-04T14:44:38Z Re: Check if the access table exists from SAS https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Check-if-the-access-table-exists-from-SAS/m-p/9138#M328 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.<BR /> <BR /> Reading the Dictionary.Tables and Dictionary.Columns SQL views will show you what exists in that library assignment.<BR /> <BR /> Kind regards<BR /> <BR /> David Mon, 07 Apr 2008 01:17:13 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Check-if-the-access-table-exists-from-SAS/m-p/9138#M328 deleted_user 2008-04-07T01:17:13Z