Data Export from Access to Excel

[Teresa NS]

I am a basic Excel user. I have been given an assignment to create a
spreadsheet that pulls information directly from the Access database. Is it
possible for me to go into a Access query that contains the fields of Name,
area, year, term, manager and populate a spreadsheet that should be divided
by year, area, manager, term name to look like the following:

2008
Operations Smith Spring Mike Jones
Summer Fred Flintstone
Fall Kathy Smith
2007
R & D Rogers Spring Mary Lamb
Summer Dough Knoll
Fall Humpty Dumpty
I need the spreadsheet to pick out by criteria to fill in one cell at a
time. For example (Year = 2008) (Area = Operations), (Term = Spring), =name

I need to do this for current year and 4 years back. Is it possible to
search for each individual cell AND have the query refresh when the workbook
in Excel is opened?

 

[FSt1]

hi
for a basic excel user, i would recoment that you use microsoft querry(MSQ).
read up on MSQ.
in 2003 it is... data>import external data>import data>follow the wizard.

post back if you have problems.

regards
FSt1

 

[Teresa NS]

I am able to get the query to run and load the data into the sheet I named
data. However I need the information in a template like spreadsheet that
will fill in the appropriate information like 2008, Operations Area, Spring
term, employee name. The boss wants this information to read individually
each cell automatically, she also wants it to update automatically every time
she opens the workbook. I can not figure out how to make it do that.

Is it possible in the Excel sheet to say "in cell A2 I need the name of the
employee who worked in Operations, 2008, spring term" and get this
information directly from the Access query and put in Excel cell A2?

Also, is there a way I can put under the year a criteria that will give me
current year + the past 4 years without having to update each year manually?