Simple move file

[J Shrimps, Jr.]

Exporting a file in delimted txt format saved
with the .txt extension.
File name is created as "Program1.txt"
File needs to be uploaded to IBM machine
as "USER.GROUP(Program)"
I can add the USER and GROUP string
to the move command (file is really not
being moved, but renamed so that the
file name fits the IBM format).

If I could figure out how to export
the file with the specified IBM naming
convention,
wouldn't need to do this, but Access
doesn't appear to let me export
a text delimited file without the .txt extension.

So, just need the move file command
in Access.
I guess.

 

[Guest]

copied from VB Editor Help:
Name Statement Example
This example uses the Name statement to rename a file. For purposes of this
example, assume that the directories or folders that are specified already
exist. On the Macintosh, “HD:†is the default drive name and portions of the
pathname are separated by colons instead of backslashes.

Dim OldName, NewName
OldName = "OLDFILE": NewName = "NEWFILE" ' Define file names.
Name OldName As NewName ' Rename file.

OldName = "C:\MYDIR\OLDFILE": NewName = "C:\YOURDIR\NEWFILE"
Name OldName As NewName ' Move and rename file.