ADDENDUM... in this class, I teach you two ways to select a file to be used in your Access database. I cover using the COMMON DIALOG control and DLL. Well, this poses a problem for people using the 64-bit versions of Access 2010 or 2013. Comdlg32 doesn't exist.

So... you can quickly and easily replace the code used to select a file by just adding these four little lines of code to your program:

Dim FO As Object
Set FO = Application.FileDialog(3)
FO.Show
MsgBox "You selected: " & FO.SelectedItems(1)


That's it. Now the path and filename of the file you selected will be in the variable FO.SelectedItems(1) and you can do with it as you please.