Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a native function for this within Access? Or would I have to do this with a batch script somehow?

Moreover, could I rename the files in a directory based on fields in an Access table?

share|improve this question

2 Answers 2

up vote 2 down vote accepted

See Dir function in VBA help to show you how to loop through a folder looking for files. Note that you must be in the VBA editor to search VBA help.

See the Name statement which "Renames a disk file, directory, or folder."

share|improve this answer

Is there a native function for this within Access? Or would I have to do this with a batch script somehow?

If you add the Microsoft Scripting Runtime as a reference you can use FileSystemObject from VBA. See here for some good examples.

Moreover, could I rename the files in a directory based on fields in an Access table?

You can do this with VBA.

share|improve this answer
    
Is there some reason you go for an outside library instead of recommending the built-in Dir() function? –  David W. Fenton Jun 12 '11 at 19:52
    
@David W. Fenton - I thought that to rename files you needed FileSystemObject but as Tony points out you can use Name. So all the functionality is built into VBA. –  ta.speot.is Jun 13 '11 at 0:30

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.