Linking Access Database to Excel Spreadsheet?

I am trying to link a Microsoft Access database to an Excel spreadsheet so that only select columns will be linked (eg. The database has a student’s name, department, year in program, etc.. but I only want the student’s name and department to populate in Excel).

I would also like to know if there is a way to set it up so that any new/revised information that is added to Access would automatically populate in Excel or if you have to manually sync the database every time you open the document.

Any tips would be greatly appreciated.

Thank you!

Sarah

1 Answer

Relevance
  • Zheia
    Lv 6
    2 years ago
    Favorite Answer

    You can use Get External Data in the data tab of Excel. From there you create the query by selecting the fields you need, and the results should appear in Excel. If the database is updated then just refresh the query.

Still have questions? Get your answers by asking now.