When you use the IMPORT procedure or the LIBNAME statement to read Microsoft Access tables, the following error can occur:
Error: File _IMEX_.yourtablename.DATA does not exist.
The problem occurs when you attempt to use data in Access tables that contain a nested query (a query that references another query).
To resolve the problem, change the query so that it only references the tables and not other queries to those tables.