append query record repeats

I am using an append query to append 15 records to a table. Access
wants to append those records 1000's of times. Every field in the
importing table is used, but the table that I'm importing to has more
fields than the importing table. Please help,

Jason

Post the SQL of your query.

" wrote:

I am using an append query to append 15 records to a table. Access
wants to append those records 1000's of times. Every field in the
importing table is used, but the table that I'm importing to has more
fields than the importing table. Please help,

Jason

wrote:
I am using an append query to append 15 records to a table. Access
wants to append those records 1000's of times. Every field in the
importing table is used, but the table that I'm importing to has more
fields than the importing table. Please help,

Jason

so did you add the fields you want to append to the final table to the
grid? Could you post the SQL and maybe the relevant structure of the
destination table?

SQL (I'm a beginner, so this is from the grid):

INSERT INTO Individuals ( Firstname, Lastname, YOB, PhoneNumber,
AddressLine, City, Zip5, Zip4 )
SELECT import2.Firstname, import2.Lastname, import2.YOB,
import2.PhoneNumber, import2.AddressLine, import2.City, import2.Zip5,
import2.Zip4
FROM import2;

Try running a select query to see how many records it pulls.
SELECT import2.Firstname, import2.Lastname, import2.YOB,
import2.PhoneNumber, import2.AddressLine, import2.City, import2.Zip5,
import2.Zip4
FROM import2;


" wrote:

SQL (I'm a beginner, so this is from the grid):

INSERT INTO Individuals ( Firstname, Lastname, YOB, PhoneNumber,
AddressLine, City, Zip5, Zip4 )
SELECT import2.Firstname, import2.Lastname, import2.YOB,
import2.PhoneNumber, import2.AddressLine, import2.City, import2.Zip5,
import2.Zip4
FROM import2;

Thanks for the help, but I think I've got it now. Jason

wrote:
SQL (I'm a beginner, so this is from the grid):

INSERT INTO Individuals ( Firstname, Lastname, YOB, PhoneNumber,
AddressLine, City, Zip5, Zip4 )
SELECT import2.Firstname, import2.Lastname, import2.YOB,
import2.PhoneNumber, import2.AddressLine, import2.City, import2.Zip5,
import2.Zip4
FROM import2;