Exporting from Access specific criteria to a specific Excel cell

  • Thread starter Thread starter Teresa NS
  • Start date Start date
T

Teresa NS

I am a beginner and have been given the assignment of creating a spreadsheet
in 2003 Excel that will get info from a Access database. Is there a way to
set up a spreadsheet to fill in the info below by year by department:

Spring: John Smith
Summer: Jane Smith
Fall: Kerrie Smith

from a database query that has the information of name, term (spring etc.),
year, department. The boss wants this to update automatically every time she
opens the workbook. I have no idea how to even start this project. Thanks!
 
Hi Teresa,

This question really belongs more in an Excel group. However, what you
want in Excel 2003 is Data menu, Import External Data, Import Data. This
assumes that the query already exists in the database. If not, you will want
the New Database Query item instead of Import Data. That should get you
headed in the right direction.

Clifford Bass
 
Back
Top