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]

Re: Using Excel data in query

aland wrote:[color=blue]
> 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
>[/color]

-----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:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQgz22IechKq OuFEgEQIOogCdGR Dka5+g+FkeoQcwF 0n8NUbH2hwAn0jO
3m4ogZ9xJHeR5V2 EGTkpSDux
=zhYB
-----END PGP SIGNATURE-----

[aland]

Re: Using Excel data in query

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