Searching for text files to import

Gurn

Registered User.
Local time
Today, 04:02
Joined
May 6, 2004
Messages
12
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...
 
Take a look at the samples & FAQ forums, you will find examples of using a file-dialog there....

Regards
 
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????
 
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
 
Thanks, that works great!!!!!!!!!!!!
 

Users who are viewing this thread

Back
Top Bottom