Exporting from Access specific criteria to a specific Excel cell

Exporting from Access specific criteria to a specific Excel cell

Post by VGVyZXNhIE » Wed, 03 Dec 2008 06:29:02


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!
--
Teresa
Norfolk Southern
Roanoke VA
 
 
 

Exporting from Access specific criteria to a specific Excel cell

Post by Q2xpZmZvcm » Wed, 03 Dec 2008 09:24:03

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