Forum Discussion
Need help importing access data into excel
Create a query in Access that joins the table you want to export with the Course Names and Instructors table. Change the joins to include ALL records from your table and only related records from the other tables.
Add all fields from your table to the query grid except Course Name and Instruc.
Instead of those two, add the corresponding fields from the other tables.
Save the query and use this instead of the table.
Create a query in Access that joins the table you want to export with the Course Names and Instructors table. Change the joins to include ALL records from your table and only related records from the other tables.
Add all fields from your table to the query grid except Course Name and Instruc.
Instead of those two, add the corresponding fields from the other tables.
Save the query and use this instead of the table.
- That worked, thanks!
