Are you not sure which Microsoft Office application these two lists are within, or is one in MS-Excel and the other in MS-Access? And it would have been helpful to know which version of these applications you are using. Plus an example of how many fields are involved, and what the data types are.
If totally within MS-Excel, select one set of data and then paste it at the end of the other set of data.
If totally within MS-Access, use an Append query to add one Table to the other Table.
If both applications, import the MS-Excel worksheet into MS-Access as a Table, then run the Append query.
Paul B
Jul 11, 2009 at 12:17 am
You could copy and paste or in MS Access use an append query.
For total Microsoft Access masteryhttp://access-databases.com/ms-access-tu…
Are you not sure which Microsoft Office application these two lists are within, or is one in MS-Excel and the other in MS-Access? And it would have been helpful to know which version of these applications you are using. Plus an example of how many fields are involved, and what the data types are.
If totally within MS-Excel, select one set of data and then paste it at the end of the other set of data.
If totally within MS-Access, use an Append query to add one Table to the other Table.
If both applications, import the MS-Excel worksheet into MS-Access as a Table, then run the Append query.
You could copy and paste or in MS Access use an append query.
For total Microsoft Access masteryhttp://access-databases.com/ms-access-tu…