Perform a search on TransferText

[cedar]

Hi all-
I have this code attached to a command button.....

DoCmd.TransferText acImportDelim, "Test Import Specification", "My Table", "C:\My folder\Myfile"

This automatically updates my table with the table in the specified folder. I would rather set up a system where the user could type in a file name, and a search would be done for the the specific file instead. Make sense?
Any ideas?
thanks

 

[SteveR77]

You could use the CommonDialog control's ShowOpen method to create the option of selecting the filename that you wanted.

Once the file name is select you could then use the Forms syntax to pass in the filename to the command as follows:

DoCmd.TransferText acImportDelim, "Test Import Specification", "My Table",&"&Me![filename field]&"

I hope this helps.

Steve