Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


application.getopenfilename in MS ACCESS??

Posted on 2006-05-01
Medium Priority
Last Modified: 2010-05-18
I have used the code "Application.getOpenFileName" in MS Excel.  I want to do the same in MS Access, so the user can choose which Excel file to import into a database.  Is there similar code I can use in Access????
Question by:mak345
1 Comment
LVL 34

Accepted Solution

flavo earned 200 total points
ID: 16581399
API: Call the standard Windows File Open/Save dialog box

There is a function in the code called TestIt that shows you how to use it.

Copy ALL the code to a new module.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question