access import method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am written a procedure that imports .txt file using transfertext method in
VBA.
These.txt files originally comes in .res file format.

I would like to change the format from access.
Is there a way i can write a procure that chanes .res files to .txt files.

Please advice

Thanks.
 
Are the .res files text files? If so, a simple rename of the file (via vba)
would suffice.

You can use the FSO in like manner:

Populate the following variables first ...
strFilePath
strFileName

Dim oFSO
Set oFSO = CreateObject("Scripting.FileSystemObject")
oFSO.CopyFile strFilePath & strFileNameData & ".res", _
strFilePath & strFileNameData & ".txt"
 
I am written a procedure that imports .txt file using transfertext method in
VBA.
These.txt files originally comes in .res file format.

I would like to change the format from access.
Is there a way i can write a procure that chanes .res files to .txt files.

Please advice

Thanks.
Click to expand...

use NAME <oldfilename> <newfilename>
no FSO required.
 
hi - could you please explain me how this works. I am kind of confused.
Please help.

thanks a lot!!!
 
Back
Top