open file dialog box - access 2000

[mudster01]

Hi All
I want to import file into access - could be text or excel but also the directory may vary each import so want to open the dialog box so user can find file...then begin import IF .xxx = txt import text else import excel.

Any ideas much appreciated.

Thanks,
M

 

[FoFa]

In the sample DB's or code base there is code to use the std file open dialog with Windows. Search for it.