[AccessD] How to Rename a flat file with Access VBA

Brad Marks BradM at blackforestltd.com
Fri Jun 24 07:44:40 CDT 2011


All,

We just installed some EDI software that creates a number of flat files.

There is one file that is a text file but the extension is .tbl

I would like to link to this file with Access 2007, but I am running
into problems because of the .tbl extension.

For the short term, I am simply renaming the file outside of Access.
This works, but I would prefer to do the renaming inside of Access.

Is there a way to use VBA to rename flat files.

Example -
Old name = C:\EDI\Outbound.tbl
New name = C:\EDI\Outbound.txt

I figure that this is pretty easy to do, but I have never done it and I
have not found an example of how to do it.

Thanks in advance for your assistance.

Brad      




More information about the AccessD mailing list