Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    problems with append queries

    HI,

    I seem to be running around in circles and hope someone can suggest what I might be doing wrong.

    I imported a large data base from Excel. I want to break the large table into smaller manageable tables. I have my Master Table and actually managed to get one append query to work after much trial and error. However none of the other ones seem to work. The query appends (0) entries, when in fact I know there should be several hundred.

    I create the table that I want the information to go into. Eg.Report Table. It has the Key column of UID (unique identifier which I determine the number) in both tables. The Report table just includes the columns relating to reports (frequency, type).

    I create the query showing by adding both tables to the query. I choose the append query. Next I select the field and table from the Master Table. The query automatically inserts the same field names into the Append To row. Once I click run I get the statement that "You are about to append 0 row(s). I've deleted and recreated the destination tables over and over again trying to ensure the data types are the same. I've added and deleted relationships between the two tables. I've checked the QUE book I have, followed the instructions, but can't figure out why one query worked and none of the others has.

    Any suggestions would be greatly appreciated. Thanks.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: problems with append queries

    If I am understanding your explanation, in design view when you are selecting the table or tables your query is based on, you are selecting the table where the data is be appended and the table where the data currently resides. You should only select the table where the data currently resides and then select the fields you want to append into the other table so that they appear in the grid at the bottom of your query window. When you click Query, Append Query from the menubar you will asked the table name of the table where the data is to be appended. Once you have done that the Append To Row will be filled in with each field that has the same name. When you have checked that everything is set up correctly, click the run button.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: problems with append queries

    Thanks I'll give it a try.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •