Re: Newbie on SQL & Excel

On Jul 17, 6:46=A0pm, Philip Wright <pvws...@[EMAIL PROTECTED]
> wrote:
> 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. =A0I 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

OK.. I might try that.  What examples do you have?