Join 2 tables with unrelated records

R

Rob S.

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

List all tables, including document structure 0
Embedded Excel into Word with Tables 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Appending tables 0
perform INNER JOIN on query results 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Show <> Records Between 2 Tables ?? (ANTI-Join) 2

Top