application.getopenfilename in MS ACCESS??

Posted on 2006-05-01
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

    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

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now