simsjr wrote ...

my boss handed me a spreadsheet that contains about 1,000 records as
retrieved by a SQL query.

My boss now wants me to run a query on ONLY the records given to me in the
spreadsheet. He wants me to grab two more fields of data for each of the
records in the sheet.
My boss says, "Someone in another department has been able to do that before."

Can anyone provide insight into how I might
accomplish what my boss wants before I tell him he's full of crap?

One of Homer's tips: 'Ooooh! Good idea, boss!'

You can use a Jet (MS Access) pass-through query to create a JOIN
between Excel data and an odbc data source using a common key. Things
your boss will need to provide include a logon to the database, user
account with appropriate permissions, location of the database, schema
details, play time... erm, I mean, project time. In other words, you
get the keys to the database, additional knowledge and skills, kudos,
pay raise, ...

No, on second thoughts, go with the 'full of crap' angle.

Jamie.

--