Transfer Text Problem - File Name too Long

[tmort]

I am working on and import form so the user can import multiple files into a
database. I have it set to work except many of the file names are longer
than 64 characters. It needs to be this way.

I would like to rename the filename right before the transfertext operation
but can't figure out how to.

Thanks for any help

 

[Robert Morley]

You're looking for the "Name" command. Here's an example:

Name "My really long filename.txt" As "ShortName.txt"


Rob

 

[Ken Snell \(MVP\)]

You can use the Name statement to rename a file:

Name "C:\Path\OriginalFilename.txt" As "C:\Path\NewFileName.txt"