Import a file using a field on a form

T

Taz

I am using Access 2003. I created a form for a user to enter the path and
filename for import. I then added a button that runs a macro to transfer the
text file. In the file name in the macro I have
forms!frmImportData!filename. It is not working. Is it possible to import a
file this way, and if so how do I do it? The filename will change each time
it is imported (a monthly run). I really don't want the user to have to open
the macro and key in the new filename each time. I'm trying to make it as
seamless as possible. TIA.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top