problems with append queries

Topic

New Reply

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.

Reply | Quote

Replies

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.

Reply | Quote

Thanks I’ll give it a try.

Reply | Quote