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

  • Thread starter Thread starter SDubois
  • Start date Start date
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.
 
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.
 
Join the two tables in a query and export the query.

Ken Sheridan
Stafford, England
 
Back
Top