I dont know if it has a solution. I tried it but I didnt found a solution.
I just know that you can do For each loop. But then you'll have alot of work with 100 Directories. It would look like this:
For each vDirectory in 'O:\Directory1\Subdirectory\ABC\LOG.mdb', 'O:\Directory1\Subdirectory\DEF\LOG.mdb', 'O:\Directory1\Subdirectory\GHI\LOG.mdb'
maybe this helps:
// replace with file or database source: Databases: LOAD * INLINE [ ID, Path 1, O:\Directory1\Subdirectory\ABC\LOG.mdb 2, O:\Directory1\Subdirectory\DEF\LOG.mdb 3, O:\Directory1\Subdirectory\GHI\LOG.mdb ]; LET vNoRows = NoOfRows('Databases') -1; for i=0 to $(vNoRows) let vDatabasePath = peek('Path',$(i),'Databases'); ODBC CONNECT32 TO [VCS Universal;DBQ=$(vDatabasePath)]; LOAD..; next