In Access I have two tables with one relationship. Need to export

S

SDubois

How can I export ALL items to a CSV file with it pulling the right data as
needed based upon the relationship I setup. It is a simple relationship with
"CITY" in both tables being linked.
 
D

Dirk Goldgar

SDubois said:
How can I export ALL items to a CSV file with it pulling the right data as
needed based upon the relationship I setup. It is a simple relationship
with
"CITY" in both tables being linked.
Click to expand...


Create a query that joins the tables and includes all the fields you want to
export. Save the query, then export the query.
 
K

Ken Sheridan

Join the two tables in a query and export the query.

Ken Sheridan
Stafford, England
 

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

Linked SQL Tables don't report Cascading Updates and Deletes 2
Complicated relationship between two tables 2
Select all entry data from two linked (with a relationship) Tables 4
One form, two tables 4
Import to many to many table 7
Access Indeterminate relationship in many-to-many table (Windows 10, Access 2016) 5
Relationship must be on the same number of fields with the same... 9
One to one relationship 0

Top