append query record repeats

  • Thread starter Thread starter jason.kohout
  • Start date Start date
J

jason.kohout

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
 
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
Click to expand...

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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Query Issue 0
Access 2010 append query to SQL is very slow 0
query field names changing to expr#: 8
Append Query isn't working 2
Criteria in append querie 3
Preventing duplicate entries with an Append Query 3
Append query without duplicate rows 3
Unable to Append All the Data to the Table 3

Back
Top