I have two tables in a single database. I would like to append the information in the NewContacts (373 records) table to the AllContacts table.
I set up an append query; when I run the query it appends each record 28 times (10444 rows).
What is going on?
Thanks
Mr. B,
When I try importing the table I get this error: An error occurred trying to import file 'C:\location.xls'. The file was not imported.
If I decide to create a new table and query them together; how could a create a query to permanently merge my new table to my old table?
Thanks, N
Hello,
I have an Access table full of customer contacts. I recently scanned in a few hundred business cards and stored the information in Excel. The Excel columns are in the same order as the Access fields. I would like to add to the Access table. How can I do this?
Thanks, Naia