Import Function to a Command Button

[Guest]

Hi,

I wan to be able to click on a command button and have it open up to look
for a txt file and once the file is selected, I want it to upload into an
existing table in access.

Any help would be appreciated.

Thanks!!!!

 

[Guest]

For the Windows File Dialog box go to
http://www.mvps.org/access/api/api0001.htm
Store the result(Filename) in the form

Once you have selected the file you can have a macro import using the
Transfer Text action.
for the file name use
=[Forms]![NameOfForm]![NameOfTextbox]

You will need to do the import once manually to create an import
specification which is used in the Transfer Text action in the macro