Question About Importing Using VBA (DoCmd.TransferText)

Hello,

I want to write a routine to import a text file into a Access desktop
application. However, I don't download to the same file each month (I
date-stamp the filename data-YYMMDD.txt).

Looks like DoCmd.TransferText is what I want, so my question is, if I don't
specify a file name and path in the code, will Access open a Windows "Open
File" box for me to point to the file, or do I need additional code?

Hope this is the right group to post this question.

Thanks,
D


.