Re: Newbie on SQL & Excel

Ty wrote:
> 
> I'm trying to restrict my query to the list of names in the Excel s/
> s(spreadsheet).
> Here are some steps given to me.  I will attempt to do this:
> 
> Drag a common field (perhaps EmployeeID) from the Excel table to the
> Pers_Table.
> This operation is called "creating an inner join". Run the query. It
> will now restrict the query to the list in the Excel file.

Now I understand. Unfortunately I have never used SQuirreL, but I
just looked at their website and looks like the kind of thing that
SQuirreL should be able to accomplish. I still think that it would
be less coding to use ADO and have the join returned as an ADO resultset.

-Philip