Specifying a Path when importing

[sush]

Hi,

I am using the transfertext method of automaticly import data.

On the form i want the user to have the option to specify a location of where the file is, rather than having to hard code the path of file. Can this be done? if so how.


Thank All

 

[MHM]

Code like this:

Dim strPath as String
strPath=me.TextFieldForPath
DoCmd.TransferText ..., ..., ..., strPath & "FileName.txt", ...

Mic