how to script copying documents

given a list of documents and their path in an access database what script do i need to 开发者_如何转开发copy all these documents from their path to a local folder without writing out each individual path into the script as the database often changes.

You don't need any "script" at all. Just use a FileCopy statement, providing the source and destination paths. It's right in the manual.

VB6 is compiled, not a scripting system like PHP or something.