Searching for text files to import

[Gurn]

I am trying to search for text files in a folder and import a particular file to a database... I can do it by hard coding it but I need the user to type the file name and and import that file... Can someone help...

 

[namliam]

Take a look at the samples & FAQ forums, you will find examples of using a file-dialog there....

Regards

 

[Gurn]

I looked there and I still can not find anything, I may be looking in the wrong place... Here is the code to put it into the DB by hard coding,
DoCmd.TransferText acImportDelim, , "tblIngredients", "C:\Formula\3241.txt", True
MsgBox "File Transfered"
I would like to open a input box and they can type in the 3241 and it will import the file, but I can not find anything on input boxes, is there an easier way????

 

[namliam]

You could put a text box on a form, with an import button

Input the numbers click the button... (presuming the files are allways located on the same folder....

Search for "dialog box" to find the sample...

Regards

 

[Dreamboat]

Gurn, looks like this is it:
http://www.access-programmers.co.uk/forums/showthread.php?t=62253

 

[Gurn]

Thanks, that works great!!!!!!!!!!!!