setting folders in odc file

C

chevmic

Hi,

I like to use Excel to view SAS datasets in Pivot Tables. I generally do itvia the SAS driver and a connexion file (ODC). I tried to create a file connecting to my SAS work library, but the problem is that the connexion doesn't seems to look at subfolders... and unfortunately SAS always creates thenew work libraries into different subfolders. Is there any way to have theconnexion file looking into subfolders? Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.odc connection managing with vba in excel 2003? 3
Connecting a Pivot Table to .Tab Data file ** Minimise the connexion setup hassle 3
Automation of scanned file storage based on content 0
Copy files in sub folders to a specific directory 1
PROBLEM OPENING FOLDERS (AAAARRRRGGGGHHH !) 0
modifying merge all workbooks.. 3
how to make table in excel visible for odbc dsn file & connect to 1
Dealing with windows 7 folder structure 6

Top