Use current date to save archival import source file Access 2007

[Jim]

Folks

I was asked to modify some VB in an access app. I've been working with
Access about a month.

orig filename AA.XYZ
new filename AA072808.XYZ where "AA"+mmddyy+".XYZ"

I have a test file, "aa.xyz" that I download from a 3rd party and import
each Monday. Following the successful import, I'd like to save it with a new
filename that includes the date in an mmddyy format , e.g., aa072808.xyz.

I know exactly how to do this in VFP and would have been finished by lunch,
but cannot seem to find my way through the commands/functions in Access 2007.

Thanks

 

[Douglas J. Steele]

Name "E:\Folder1\Folder2\AA.XYZ" As "E:\Folder1\Folder2\AA" & Format(Date,
"mmddyy") & ".XYZ"

 

[Jim]

Thanks Douglas! With FileCopy this is exactly what I needed.

Now to find my way through the rest of this undocumented code!