How to have Access copy a .txt file to another folder

  • Thread starter Thread starter Bucky
  • Start date Start date
B

Bucky

Is it possible to have Access make a copy of a .txt file to another
folder on a network? I have users upload a .txt file to the system,
but after it's uploaded, I want Access to copy the original .txt file
to a "backup" directory so I have a running history of everything
that's been uploaded. Is this possible? How?
 
The following line of code should do it:

FileCopy strSourceFile, strDestinationFile

Where strSourceFile is a string with the full file name and path of the
file to be copied and strDestinationFile is the full name and path of
the copy file. You can rename it in the copy but you don't have to.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting 'Smart Quotes' out of Access 7
Wanting to grab group of files and PkZip them. 6
Problem deleting a .txt file 6
Please help before I go nuts with the batch file 5
Batch file for file list 2
Export to TXT file 4
Convert mdb file to txt file 4
Import txt-files using Wild-cards in file_name 6

Back
Top