Using Excel data in query

[aland]

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

[MGFoster]

aland wrote:

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

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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.

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

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgz22IechKqOuFEgEQIOogCdGRDka5+g+FkeoQcwF0n8NU bH2hwAn0jO
3m4ogZ9xJHeR5V2EGTkpSDux
=zhYB
-----END PGP SIGNATURE-----

[aland]

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