Access Macro Import

Posted on 2009-04-27
Last Modified: 2013-11-27
I am creating a Macro, with Transfer.Spreadsheet, Import.

I have entered all the required information, including the path of the Excel file to be imported. When I attempt to execute, I get this message "Operation Must Use an Updateable Query."

1. It does not make sense why thie Macro cannot run stand alone, and why a Query is needed.
2. If a query is definitely needed, please confirm the code/query to be used

Question by:tahirih
    LVL 5

    Accepted Solution

    This looks like a permission issue. Look at this article and apply the same changes in your macro.

    Author Comment

    I have read through this. How can I resolve it?


    Author Comment

    I have attempted to fix this unsuccessfully. Please advise. Thanks.

    Author Closing Comment


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now