external data query

[Dr. Logic]

in access I can use join properties but what can i do in excel if I want to include records from two different tables? is there a join in microsoft query? any way to do that?

 

[Trustee]

Hi there,

Open a new or existing database.
On the Create tab, in the Tables group, click Table.Double-click the first cell in the header row, and then type the name of the field in the sample table.
By default, Access denotes blank fields in the header row with the text Add New Field

Use the arrow keys to move to the next blank header cell, and then type the second field name. (You can also double-click the new cell.) Repeat this step for each field name.
Enter the data in the sample table.
As you enter the data, Access infers a data type for each field. Each field has a specific data type, such as Number, Text, or Date/Time. Setting data types helps ensure accurate data entry and also helps prevent mistakes, such as using a telephone number in a calculation. For these sample tables, allow Access to infer the data type, but be sure to review the data type that Access infers for each field.
After you finish entering the data, click Save, or press CTRL+S.
The Save As dialog box appears.
In the Table Name box, type the name of the sample table, and then click OK

Hope this can help you

 

[Fazza]

hi

Yes, you should be able to do all the same joins in MS Query as in Access.

Please refer to help in MS Query on joins.

It will be similar to https://support.microsoft.com/en-us/kb/136699

hth