VJ,   Do you know which version of - SAS Software you have? - Which SAS/ACCESS product you have (SAS/ACCESS to OLE DB/ODBC)?   Once you have answered the above two questions, then you can find sample code in the relavant documentation here SAS/ACCESS 9.x for Relational Databases: Reference,     Note: There are no single code that works for all databases, therefore you shouldn't count on someone to provide you a working code for your database! Read the doc and adopt the code to your settings and environment.   Hope this helps, Ahmed ... View more