Choose various files to import

[MLD]

I'm able to import various text files with TransferText in a macro, but that
limits me to a single default filename and location. The text files are
always the same format and they always go into the same table, but they have
various filenames, like test20050526 and test20050527. How can I bring up a
select file box in a macro?

 

[Douglas J. Steele]

Not sure you can in a macro, but it's pretty standard to do that using VBA.
Check http://www.mvps.org/access/api/api0001.htm at "The Access Web" for
instructions on how to use the standard Windows File Open dialog.