Results 1 to 3 of 3
  1. #1
    emma313823 is offline Novice
    Windows 10 Office 365
    Join Date
    Jan 2021
    Posts
    1

    Append Query not working


    Hi All

    In a bit of a bind as to why this is not working. I have some excel worksheets that hold dat for 2019, 2021 and of course now 2021. Each file is pulled into an access database via linking. Each month, I will update the linked table manager. I have a table called Combined Data, whereby I've created three append queries for each year. I created a Query Design, pulled in the 2020 table pulling in all fields, selected Append from the ribbon and have it set to append to the COMBINED DATA table and selected save. When I try to run that query either through the ribbon (RUN) or by double-clicking nothing happens at all. Oddly, I had a similar access database set up for something else where I did this same thing and have been using this for about 2 years simply double-clicking on the append query to run it, but now these append queries also do not work.
    Can anyone offer any assistance as to how to get this to run?
    Emma

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    nothing happens at all
    I doubt that very much. It likely runs but doesn't do what you expect. Examine the query, especially the sql view. Perhaps that view will point out the problem. Can also try switching from sql view to datasheet view. This view of an action query will show you how many records should be affected (not necessarily the actual effect), often showing empty records. If you get none, something is wrong with your query (criteria or links) based on your expectations. The foregoing assumes you have not disabled warnings at some point.
    Last edited by Micron; 01-20-2021 at 01:04 PM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    instead of importing manually each time,do it this way:

    1. save the file (excel, or text) to a generic name everytime: c:\temp\File2import.xls (or File2import.txt)
    2. attach (link) the file as an external table, like tFile2Import
    3. make a query that appends data from tFile2Import table to the target table.
    this query would use * to import all fields with the same name, but if the 2 tables dont have the same names, you must add the source fields and target fields to the query.
    4. put this query in a macro, run the macro.


    Once this is done, the import steps are now:
    1. save the new file and overwrite the old one
    2. run the macro
    done.

    now what this does is let you open the append query and it will tell you what is wrong. A field is missing , or mispelled,etc.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Append query not working
    By rayted in forum Queries
    Replies: 1
    Last Post: 03-05-2018, 05:22 AM
  2. Append Query not Working for Specific User
    By heather in forum Access
    Replies: 8
    Last Post: 01-09-2017, 03:15 PM
  3. Append Query Stops Working in RunSQL Command Question
    By McArthurGDM in forum Programming
    Replies: 6
    Last Post: 06-11-2015, 11:17 AM
  4. Replies: 1
    Last Post: 01-16-2013, 10:58 AM
  5. Append query not working
    By seth.murphine in forum Queries
    Replies: 5
    Last Post: 04-20-2012, 06:41 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums