Import .txt file Dialog Box to Choose File?

  • Thread starter Thread starter Bill Johnson
  • Start date Start date
B

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,

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
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top