Exporting from Access specific criteria to a specific Excel cell

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!
 
C

Clifford Bass

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top