Message for Arvin on Doc Mgmt Database

S

scubadiver

cont ....

But what I need to do is create a table for all documents in the folder
excluding the subdirectories.
 
A

Arvin Meyer [MVP]

Traversing the directory structure can only be accomplished by looking into
the subdirectories. You can eliminate the subdirectories by moving the files
into the main directory, and deleting the subdirectories. You can also run
an update query and eliminate the data in the field. For instance:

C:\Projects\CFCS\010607\
and:
C:\Projects\Data\

can be updated to:

C:\Projects\

with something like:

UPDATE TableName SET TableName.Path = Left([Path],12);
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
 
S

scubadiver

I realised the simplest thing would be to use your database and then
transfer the information.




Arvin Meyer said:
Traversing the directory structure can only be accomplished by looking into
the subdirectories. You can eliminate the subdirectories by moving the files
into the main directory, and deleting the subdirectories. You can also run
an update query and eliminate the data in the field. For instance:

C:\Projects\CFCS\010607\
and:
C:\Projects\Data\

can be updated to:

C:\Projects\

with something like:

UPDATE TableName SET TableName.Path = Left([Path],12);
--
Arvin Meyer, MCP, MVP
Microsoft Access
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

scubadiver said:
cont ....

But what I need to do is create a table for all documents in the folder
excluding the subdirectories.
Click to expand...
Click to expand...
 
Top