rename external file using DAO/ADO

A

ac

Hi all,

Is there way to rename my external files from ABC.20030501.01.TXT to
ABC2003050101.TXT so that i can import with transfertext command?
I have 100 files generated everyday and a loop procedure to process al files
will be helpful.

Thanks
ac.
 
C

Cheryl Fischer

The Name statement in VBA might work for you:

Name "OldName.txt" As "NewName.txt"

hth,
 
A

ac

Yes Cheryl, thanks, that works with a while loop and concatenating the file
name.

cheers,
Pan
 

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

Importing a LARGE # of .txt files at once 1
Transfer Text error 31519 2
Access 2003: Import Extensionless Files 3
Open import file by date 4
Why is there no .txt option in the Access/File/Get External Data/. 2
Copy and rename a text file 4
Access macro Import txt file makes zipcodes numeric losing lead 0 1
File to import is systematically created with date as file name. 3

Top