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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import from Notepad delimited text 7
.DAT Files - URGENTS PLEASE HELP 2
Opening multiple txt files into one workbook as separate sheets 2
restore .dat 1
McAfee VirusScan DAT updater 15
data import 1
import data 1
Determine File Filter Selected 1

Back
Top