Retrieving External Data from Access into Excel

[Vicki]

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

 

[Frank Kabel]

Hi
I would setup a query like this directly in Access and use 'Data -
Import - External Data' to access this query

--
Regards
Frank Kabel
Frankfurt, Germany

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).