Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / August 2005

Tip: Looking for answers? Try searching our database.

Need Current Path to import TXT file

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Birk Binnard - 24 Aug 2005 20:31 GMT
The TransferText command requires passing the full path and filename of
the TXT file to be imported.  My users put the text file in the same
folder as the Access application itself.  But how do I get the path name
of that folder?

The CurDir function does not do it. That function seems to return either
the computer's default path or the path to My Documents, neither of
which is what I need.  The Access application is located on a mapped
network server drive and I have currenrtly hard coded the path into the
TransferText parameter string.  But if teh drive mappings change I'm in
trouble.

I thought the Application object would have the proper path in it
somewhere, but I can't find anything like that there.  Is there
someplace else I shoudl look?
Signature

Birk Binnard
http://www.birkbinnard.com

Ken Snell [MVP] - 24 Aug 2005 20:52 GMT
This will tell you the path where your "front end" application file is
located:
CurrentProject.Path

Signature

       Ken Snell
<MS ACCESS MVP>

> The TransferText command requires passing the full path and filename of
> the TXT file to be imported.  My users put the text file in the same
[quoted text clipped - 11 lines]
> somewhere, but I can't find anything like that there.  Is there someplace
> else I shoudl look?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.