Choose various files to import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MLD - 28 May 2005 15:52 GMT

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?

Reply to this Message

Douglas J. Steele - 28 May 2005 22:13 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I'm able to import various text files with TransferText in a macro, but
> that
[quoted text clipped - 4 lines]
> a
> select file box in a macro?

Reply to this Message