trasnfer to text

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

Guest

the trasnfertxt macro doesn't allow for creating a .dat file, is there anyway
i can either cdreate a .dat file within access or have access run a batch
file that will renamd the .txt file to a .dat file
Don
 
the trasnfertxt macro doesn't allow for creating a .dat file, is there anyway
i can either cdreate a .dat file within access or have access run a batch
file that will renamd the .txt file to a .dat file
Don
Click to expand...

look at FileCopy and Kill in the help file
 
In Access 97 SR-2 and later, TransferText does have to export to a
registered file type such as .txt or .csv.

You can use the Name file to rename it afterwards. Naturally that doesn't
change the structure though (e.g. if you .dat file expects different header
information.)
 
Back
Top