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

MS Query

P: n/a
Hi, I'm a newbie, and I'm not sure I've come to the right place.

I have inherited a 95% developed access xp database, and some 95%
developed excel reports. Up to now my predecessor has been copying and
pasting the info from access onto the excel spreadsheet for the update
of the reports, my task is to automate the existing system. I can do
that using MS Query to import the data from Access to Excell, but I
have many queries on one sheet, and many virtualy identical reports
(spreadsheets) to complete, what I want to do is link the criteria in
the query to a cell in the spreadsheet.

Select * from Table_A_in_Access where X = (Cell_A1_on_the_spreadsheet)

Thanks in advance.

Jenni
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Wouldn't this question better be asked in an Excel newsgroup? It'll only be
a happy happenstance if you find someone here who does this from the Excel
side. You'd find people here, perhaps, who control Excel from Access via
automation.

Larry Linson
Microsoft Access MVP

"Jenni" <jr*******@khulisa.com> wrote in message
news:db*************************@posting.google.co m...
Hi, I'm a newbie, and I'm not sure I've come to the right place.

I have inherited a 95% developed access xp database, and some 95%
developed excel reports. Up to now my predecessor has been copying and
pasting the info from access onto the excel spreadsheet for the update
of the reports, my task is to automate the existing system. I can do
that using MS Query to import the data from Access to Excell, but I
have many queries on one sheet, and many virtualy identical reports
(spreadsheets) to complete, what I want to do is link the criteria in
the query to a cell in the spreadsheet.

Select * from Table_A_in_Access where X = (Cell_A1_on_the_spreadsheet)

Thanks in advance.

Jenni

Nov 12 '05 #2

P: n/a
Yes, but as I said I'm new at this. Anyone know where I can find an
excell group out there? There does not seem to be one listed in the
Google directory.

"Larry Linson" <bo*****@localhost.not> wrote in message news:<xG*****************@nwrddc03.gnilink.net>...
Wouldn't this question better be asked in an Excel newsgroup? It'll only be
a happy happenstance if you find someone here who does this from the Excel
side. You'd find people here, perhaps, who control Excel from Access via
automation.

Larry Linson
Microsoft Access MVP

"Jenni" <jr*******@khulisa.com> wrote in message
news:db*************************@posting.google.co m...
Hi, I'm a newbie, and I'm not sure I've come to the right place.

I have inherited a 95% developed access xp database, and some 95%
developed excel reports. Up to now my predecessor has been copying and
pasting the info from access onto the excel spreadsheet for the update
of the reports, my task is to automate the existing system. I can do
that using MS Query to import the data from Access to Excell, but I
have many queries on one sheet, and many virtualy identical reports
(spreadsheets) to complete, what I want to do is link the criteria in
the query to a cell in the spreadsheet.

Select * from Table_A_in_Access where X = (Cell_A1_on_the_spreadsheet)

Thanks in advance.

Jenni

Nov 12 '05 #3

P: n/a
TC
When I go to www.google.com & type excel newsgroup I get 67,000 hits.

Maybe there is one in there somewhere?

HTH,
TC
"Jenni" <jr*******@khulisa.com> wrote in message
news:db*************************@posting.google.co m...
Yes, but as I said I'm new at this. Anyone know where I can find an
excell group out there? There does not seem to be one listed in the
Google directory.

"Larry Linson" <bo*****@localhost.not> wrote in message

news:<xG*****************@nwrddc03.gnilink.net>...
Wouldn't this question better be asked in an Excel newsgroup? It'll only be a happy happenstance if you find someone here who does this from the Excel side. You'd find people here, perhaps, who control Excel from Access via
automation.

Larry Linson
Microsoft Access MVP

"Jenni" <jr*******@khulisa.com> wrote in message
news:db*************************@posting.google.co m...
Hi, I'm a newbie, and I'm not sure I've come to the right place.

I have inherited a 95% developed access xp database, and some 95%
developed excel reports. Up to now my predecessor has been copying and
pasting the info from access onto the excel spreadsheet for the update
of the reports, my task is to automate the existing system. I can do
that using MS Query to import the data from Access to Excell, but I
have many queries on one sheet, and many virtualy identical reports
(spreadsheets) to complete, what I want to do is link the criteria in
the query to a cell in the spreadsheet.

Select * from Table_A_in_Access where X = (Cell_A1_on_the_spreadsheet)

Thanks in advance.

Jenni

Nov 12 '05 #4

P: n/a
OK, Thanks. Sorry for asking a dumb question.

I have solved the problem anyway by running 19 append queries in a
macro, and (hopefully) letting them be dependant on the value of a
combo box. Then the excel sheet only needs one MS Query to retrieve
the relevant data from one table. Now I only need one spreadsheet
instead of a potential 200.

Thank all the Gods we live and learn!!
Jenni

"TC" <a@b.c.d> wrote in message news:<1066805067.194939@teuthos>...
When I go to www.google.com & type excel newsgroup I get 67,000 hits.

Maybe there is one in there somewhere?

HTH,
TC
"Jenni" <jr*******@khulisa.com> wrote in message
news:db*************************@posting.google.co m...
Yes, but as I said I'm new at this. Anyone know where I can find an
excell group out there? There does not seem to be one listed in the
Google directory.

"Larry Linson" <bo*****@localhost.not> wrote in message

news:<xG*****************@nwrddc03.gnilink.net>...
Wouldn't this question better be asked in an Excel newsgroup? It'll only be a happy happenstance if you find someone here who does this from the Excel side. You'd find people here, perhaps, who control Excel from Access via
automation.

Larry Linson
Microsoft Access MVP

"Jenni" <jr*******@khulisa.com> wrote in message
news:db*************************@posting.google.co m...
> Hi, I'm a newbie, and I'm not sure I've come to the right place.
>
> I have inherited a 95% developed access xp database, and some 95%
> developed excel reports. Up to now my predecessor has been copying and
> pasting the info from access onto the excel spreadsheet for the update
> of the reports, my task is to automate the existing system. I can do
> that using MS Query to import the data from Access to Excell, but I
> have many queries on one sheet, and many virtualy identical reports
> (spreadsheets) to complete, what I want to do is link the criteria in
> the query to a cell in the spreadsheet.
>
> Select * from Table_A_in_Access where X = (Cell_A1_on_the_spreadsheet)
>
> Thanks in advance.
>
> Jenni

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.