https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Import-all-Access-tables-in-a-folder/m-p/1415#M84 Chip:<BR /> You might try checking out this PROC IMPORT sample program on the Tech Support site. It shows how to read files from a directory and then use PROC IMPORT on the files. <BR /> <BR /> Sample 157: Reading multiple files with PROC IMPORT <A href="http://support.sas.com/ctx/samples/index.jsp?sid=157" target="_blank">http://support.sas.com/ctx/samples/index.jsp?sid=157</A><BR /> <BR /> cynthia Sat, 16 Sep 2006 13:50:31 GMT Cynthia_sas 2006-09-16T13:50:31Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Import-all-Access-tables-in-a-folder/m-p/1414#M83 Is there a way to import all Microsoft Access tables found within a network folder without naming them specifically? I will have a monthly folder that will be populated with several access databases. I need to read them all in but I'd prefer not to have to change the code each month to specifically name each database.<BR /> <BR /> Thanks! Fri, 15 Sep 2006 17:47:09 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Import-all-Access-tables-in-a-folder/m-p/1414#M83 Chip 2006-09-15T17:47:09Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Import-all-Access-tables-in-a-folder/m-p/1415#M84 Chip:<BR /> You might try checking out this PROC IMPORT sample program on the Tech Support site. It shows how to read files from a directory and then use PROC IMPORT on the files. <BR /> <BR /> Sample 157: Reading multiple files with PROC IMPORT <A href="http://support.sas.com/ctx/samples/index.jsp?sid=157" target="_blank">http://support.sas.com/ctx/samples/index.jsp?sid=157</A><BR /> <BR /> cynthia Sat, 16 Sep 2006 13:50:31 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Import-all-Access-tables-in-a-folder/m-p/1415#M84 Cynthia_sas 2006-09-16T13:50:31Z