Retrieving External Data from Access into Excel

[Guest]

Good day all

PART I: I have a spreadsheet that lists the time of day (8:00 a.m. - 9:30 p.m.) and the days of the week (Monday-Friday).

PART II: There is an existing Access database, Course Schedule, that has a query named "Summer 2004.

My boss wants me to retrieve data from the database query and put it in the excel spreadsheet (i.e., "Birenbaum" teaches "crs no" and "section" on "day1" from "starttime1" to "4endtime1" in "room" from "date1" to "date2", etc.). The end result would be a single page for each instructor showing what days/times of the week that instructor teaches.

I'm not a programmer, but I was hoping that I could write a formula that would search the database query and return the information in the column matching the criteria (i.e., Monday, Tuesday, Wednesday, Thursday, Friday)

Any suggestions?? Thank you and take care

Vicki

 

[nath]

Hi Vicki.

There are a number of ways of doing this, you could copy
the latest version of your table and use excel worksheet
functions or you could code a link to access. If you go
to the data menu, then select get external data source.
It is probably best to have a play with that first. If
you have any further problems require help with the
coding, email me on (e-mail address removed) and i will
do my best to help you.

Hope this helps

Nath.

-----Original Message-----
Good day all!

PART I: I have a spreadsheet that lists the time of day

(8:00 a.m. - 9:30 p.m.) and the days of the week (Monday-
Friday).

PART II: There is an existing Access database, Course

Schedule, that has a query named "Summer 2004."

My boss wants me to retrieve data from the database query

and put it in the excel spreadsheet (i.e., "Birenbaum"
teaches "crs no" and "section" on "day1" from "starttime1"
to "4endtime1" in "room" from "date1" to "date2", etc.).
The end result would be a single page for each instructor
showing what days/times of the week that instructor
teaches.

I'm not a programmer, but I was hoping that I could write

a formula that would search the database query and return
the information in the column matching the criteria (i.e.,
Monday, Tuesday, Wednesday, Thursday, Friday).