Using Excel data in query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aland - 11 Feb 2005 15:46 GMT

I've got an Excel spread sheet with one row of id's and I'd like to use
these in a query and put the results into Excel.
Basically I'd like to do something like
SELECT txtFileTitle, txtFileYear FROM tblFiles WHERE fileID =
[Sheet1]![A1] if that makes sense.
Any help appreciated
-Alan

Reply to this Message

MGFoster - 11 Feb 2005 18:17 GMT

> I've got an Excel spread sheet with one row of id's and I'd like to use
> these in a query and put the results into Excel.
[quoted text clipped - 3 lines]
> Any help appreciated
> -Alan

Name the area in the Excel s/s that holds the IDs. Save the file. Link
the Excel s/s to an Access .mdb file. Set up the query in Access using
the linked xls table. Save the query when it works as you want. In
Excel use the Import External Data item on the Data menu to run the
query you just created in Access.

OR

Import the Excel IDs to a table in Access. Set up the query. Export
the query to Excel.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message

aland - 12 Feb 2005 14:49 GMT

Cool, that's a much easier way to do it than I was going to. Cheers for
that.

Reply to this Message