Add date and timestamp to export file created in Access 1

[ajv]

We have several MS Access applications where we create text files from MS Access. We use macros to create the output file. However each new file overwrites the previous one. Can someone help with either VBA code or Access query that would add the data and time stamp to the output file name.

Example: Text file created is output.txt
Would like to add data and time so file name would be
20030224_output.txt

Doing this in UNIX is easy but how do I do this in a MS environment?.

Thanks.

 

[beetee]

the VBA code would be:

Function MakeTimeStampFileName(InputName As String) As String
Dim DotPos As Integer
DotPos = InStr(InputName, ".&quot
MakeTimeStampFileName = Left(InputName, DotPos - 1) & "_" & Format(Now, "YYYYMMDD&quot & Right(InputName, Len(InputName) - DotPos + 1)
End Function