.txt import

[awake2424]

In Access 2003 is it possible to create a button that auto-imports a .TXT file? I would like the user to click the button and be directed to a directory of .TXT files. Then the correct file is selected and is exported to the Access form. Thanks.

 

[Premy]

Well, for the file picking routine u could check out "Filedialog" in VB help. Then u can save the path to the .txt file in a hyperlink field, so when someone clicks it in a form, it'll open the associated .txt file.

HTH