BookmarkSubscribeRSS Feed
Chip
Calcite | Level 5
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.

Thanks!
1 REPLY 1
Cynthia_sas
Diamond | Level 26
Chip:
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.

Sample 157: Reading multiple files with PROC IMPORT http://support.sas.com/ctx/samples/index.jsp?sid=157

cynthia

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Discussion stats
  • 1 reply
  • 1236 views
  • 0 likes
  • 2 in conversation