Join 2 tables with unrelated records

G

Guest

I've imported 2 tables from Excel.
Each has the same number of records.
Each table has 1 field, unrelated to other table.
Is there a way to join the 2 tables into one table that has 2 fields, using
the order that the records appear in the original tables as the "relation"?
In other words, the first record in the new table would have the two fields
holding data from the 1st records of the original tables.

I've been using DoCmd.RunSQL, but when I tried to use JOIN Access appended
one table to the other.

Thank you for any suggestions
 
M

Michel Walsh

Append the data into a table that will have an autonumber as extra field
(supplying the 1, 2, 3, ... sequence) for each of the two tables. Next, join
on that autonumber, appropriately.


Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Have both records from two queries/tables under one Query without related fields. 0
Show <> Records Between 2 Tables ?? (ANTI-Join) 2
How stop Append from sorting records? 3
perform INNER JOIN on query results 2
Join Properties 1
Query based on two unrelated tables 2
Left join in query 12
outer join with multiple fields 3

Top