Import file

N

Nashwa

Hi all,
i'm really new to Access and VB, so i need your help.
i need to import a file to the db by browesing my computer for the file
instead of specifying the whole file path and name. how can this be done ??!!!

please help me.
thanks.
 
D

Douglas J. Steele

Take a look at http://www.mvps.org/access/api/api0001.htm for how to browse
for a file.

While it may be overwhelming-looking code (even if you are experienced with
VBA <g>), all you have to do is copy everything between Code Start and Code
End into a new module (not a class module nor a module associated with a
form), and put code like what's at the top of the page wherever you want to
invoke the dialog.
 
Top