Transfer Text Problem - File Name too Long

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tmort - 21 Mar 2008 21:14 GMT

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

Reply to this Message

Robert Morley - 21 Mar 2008 22:10 GMT

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

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

Rob

> 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
[quoted text clipped - 4 lines]
>
> Thanks for any help

Reply to this Message

Ken Snell (MVP) - 22 Mar 2008 03:33 GMT

You can use the Name statement to rename a file:

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

Signature

Ken Snell
<MS ACCESS MVP>

>I am working on and import form so the user can import multiple files into
>a
[quoted text clipped - 6 lines]
>
> Thanks for any help

Reply to this Message