By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,044 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,044 IT Pros & Developers. It's quick & easy.

Using Excel data in query

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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-----
Nov 13 '05 #2

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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.