File list to Access

[zliazmei]

Hi There!

May be here is not exact place for looking for a answer but:

Have the problem.
How can I Make a table in Access that will look for a files *.dwg in a subfolder named "SUB".

Just A simple file storage but I can not find the decision

ZMEI

 

[209larry]

zliazmei,


1. Make a batch file (*.bat) which contains this text for example:

dir c:\sub\*.dwg/b >c:\sub\dirlist.txt

2. save it say on c:\sub\dirbat.bat

3. prepare RunApplication on macro with command line c:\sub\dirbat.bat


4. Run macro

5. Attach the text output dirlist.txt as linked table.

209larry