<div>
I would suggest you add more details about the 2 tables, there isn't much here that can be answered right now.<br />
<br />
e.g.<br />
sample data (from both tables), and<br />
expected result (from that sample)
</div>


I would suggest you add more details about the 2 tables, there isn't much here that can be answered right now.

e.g.
sample data (from both tables), and
expected result (from that sample)

<div>
You can try to use union query, but it need similar fields. You can add intermediate queries, based on your tables, where you can add missing fields and use these queries in union query.
</div>


You can try to use union query, but it need similar fields. You can add intermediate queries, based on your tables, where you can add missing fields and use these queries in union query.

<div>
<div class="content wysiwyg-content">
I have two tables that are not related and do not have the same fields. &nbsp; I want to know how I can merge those two tables to together or insert information in one table into the other?
</div>
</div>


I have two tables that are not related and do not have the same fields.   I want to know how I can merge those two tables to together or insert information in one table into the other?

Microsoft Access tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.