Retrieving External Data from Access
 

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