Forum Discussion

ekane1's avatar
ekane1
Copper Contributor
Dec 20, 2021
Solved

Need help importing access data into excel

Hello all,   I am looking to import my training database from access into excel and am having difficulties. Once the importing process is complete, everything looks good except for a couple fields....
excel
office 365
  • HansVogelaar's avatar
    HansVogelaar
    Dec 20, 2021

    ekane1 

    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.

HansVogelaar's avatar
HansVogelaar
MVP
Dec 20, 2021

ekane1 

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.

ekane1's avatar
ekane1
Copper Contributor
Dec 21, 2021
That worked, thanks!

Resources