Import file with a standard Microsoft open windo

[paulette33]

In the database that I'm building, I need to import an Excel file and append that data into an existing data. Rather than having a set location where the file is stored, is it possible to have a dialog that looks similar to the Windows open file dialog box, where the user can specify the file location and file name?

Thanks in advance!

 

[RickSpr]

Search the FAQ area. There are several FAQs that describe how to use the actual Windows Common Dialog Box. It returns a full path to the file name selected by the user, and you can then just do a TransferSpreadsheet.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein