Import .txt file Dialog Box to Choose File?

[Bill Johnson]

Is there VBA code that will allow me to choose which .txt
file from a folder to import?

Thanks for your help

 

[John Nurick]

Hi Bill,

There are various ways of doing this. Probably the most reliable is at
http://www.mvps.org/access/api/api0001.htm . This gets you the folder
and filename, which you can then pass to DoCmd.TransferText.

 

[Bill Johnson]

John,

Thanks! That worked great. It also gave me
some additional education.

Bill

-----Original Message-----
Hi Bill,

There are various ways of doing this. Probably the most reliable is at
http://www.mvps.org/access/api/api0001.htm . This gets you the folder
and filename, which you can then pass to DoCmd.TransferText.

Is there VBA code that will allow me to choose which .txt
file from a folder to import?

Thanks for your help

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.