Transfer Text.

[Guest]

I'm trying to put together a simple app that imports a text file. I want to
keep this as simple as possible. I don't want to set up folders and code
for specific paths. I would like the user to click the Import button and
specify the file to be imported, then have the code take over and do the
rest. I've saved the import specification. The usual DoCmd.TransferText
only works if you specify a specific file. Is there a function I can
substitute that will do this for me?

Thanks,

Paul Hammond
Richmond, VA

 

[Ken Snell [MVP]]

To let them pick the text file, check out
http://www.mvps.org/access/api/api0001.htm

This enables you to call a function that opens a browse window, and then you
can use the path/filename returned by the function in your TransferText
action.

 

[Guest]

I meant to thank you for this earlier. I've had trouble accessing this
website recently. Your code worked great. Appreciate the help.

Paul Hammond
Richmond, VA

 

[Ken Snell [MVP]]

Code isn't mine, but glad it worked for you!