By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

Move files based on file names in table

P: n/a
I've seen a couple postings on moving files to folders with set source
and destination paths, but I still need a little help taking it a step
further. I have a folder with 2,000 Word docs that I generated using
Word automation. Since the file names were generated from a table in
Access, I would then like to use Access to sort those files into
various folder based on names stored within the table.

For example:

There is a Word doc named "Account Management - ADA Compliance.doc"

My table shows that the location of this file should be "B - Account
and Benefit Administration"

So, how can I 1) read the file names in Windows, 2)flip through the
table and move each of the 2,000 files into one of 21 folders.

Thanks much for your help.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Stein wrote:
I've seen a couple postings on moving files to folders with set source
and destination paths, but I still need a little help taking it a step
further. I have a folder with 2,000 Word docs that I generated using
Word automation. Since the file names were generated from a table in
Access, I would then like to use Access to sort those files into
various folder based on names stored within the table.

For example:

There is a Word doc named "Account Management - ADA Compliance.doc"

My table shows that the location of this file should be "B - Account
and Benefit Administration"

So, how can I 1) read the file names in Windows, 2)flip through the
table and move each of the 2,000 files into one of 21 folders.

Thanks much for your help.


Dir
FileCopy
Kill

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.