Re: csv report renaming before import
- From: "Ken Snell \(MVP\)" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 17 Jul 2007 17:45:35 -0400
Import specifications do not rely on the name of the file being imported. I
assume that you're looking for wanting to have the right filename in the
FileName argument of TransferText?
Check out the Name statement in VBA:
Name Path\Folder\OldFilename.csv As Path\Folder\NewFilename.csv
--
Ken Snell
<MS ACCESS MVP>
"fishy" <fishy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:37DF3E7F-5911-47F3-A357-56B2720DAD88@xxxxxxxxxxxxxxxx
I have 12 daily csv reports that have a autonumber added to a standard
naming
convention.
Is there anyway of renaming these files from a database so that my normal
import spec works without having to manually amend the file names.
.
- Prev by Date: Re: Correct mask to import date from .txt file?
- Next by Date: Re: Correct mask to import date from .txt file?
- Previous by thread: Re: Correct mask to import date from .txt file?
- Next by thread: Re: csv report renaming before import
- Index(es):
