copy a list of files in a table to new directory

[niksto]

In an access 2k table named copythese I have a field named workfiles
including the path and filename of files; like d:\_aa\customer\1202.bmp in
the field
logo (saved as text).
These files are listed in my table due to a query and selected from a lot of
other files.

I want access to copy these files to a new directory d:\mycopy placing all
in the
same directory (no subdirectory)

Any idea or examplecode?

 

[Dirk Goldgar]

In an access 2k table named copythese I have a field named workfiles
including the path and filename of files; like
d:\_aa\customer\1202.bmp in the field
logo (saved as text).
These files are listed in my table due to a query and selected from a
lot of other files.

I want access to copy these files to a new directory d:\mycopy
placing all in the
same directory (no subdirectory)

Any idea or examplecode?

Answered in another newsgroup to which you posted this question
independently.. That's called "multiposting", and it's generally
frowned on because others don't know what answers have already been
given, and so they duplicate the effort. Also it's harder for you to
keep track of the various replies, and it's harder for later readers of
the question, who may be looking for the same answer, to learn what they
need.

In most cases a single, well-chosen newsgroup will do. If your question
really is relevant to more than one newsgroup, the approved technique is
to "crosspost" it instead, by listing multiple newsgroups in the To: or
Newsgroups: line of a single message. If you do that, the message and
any replies will appear in all the listed newsgroups automatically,
which is beneficial to all concerned.

 

[TC]

Dirk's point is well made. I was about to draft some code for you, when I
read his reply. I would have been veeeery upppppset to find that I had
wasted my time, because someone else had already answered it somewhere else


TC