Forum home » Delegate support and help forum » Microsoft Access Training and help » Append table
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Append table
Resolved · Low Priority · Version 2003
Reply Fri 14 Nov 2008, 17:06Delegate Pauline said...
Pauline has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Append table
can you append tables which have different fields?
For upcoming training course dates see: Pricing & availability
RE: append table
Dear Pauline
Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
When you append records from one table to another it is important that both the tables should have the same fields. Normally the main purpose of append query is to copy and paste new records from one table to another.
If you have primary key in your tables please ensure that the data doesn't duplicate otherwise the Append query will not work.
If you can provide a more specific example as to what you want the append query to do then I should be able to look into it more thoroughly.
Meanwhile the following link should be of some help to you:
http://office.microsoft.com/en-us/access/HA100765261033.aspx?pid=CH100645771033
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Mon 12 Jan 2009: Automatically marked as resolved.
|