Hi Teresa,
This question really belongs more in an Excel group. However, what
you
want in Excel 2003 is Data menu, Im****t External Data, Im****t Data. This
assumes that the query already exists in the database. If not, you will
want
the New Database Query item instead of Im****t Data. That should get you
headed in the right direction.
Clifford Bass
"Teresa NS" wrote:
> 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
|
