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>...[color=blue]
> 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" <jrobinson@khulisa.com> wrote in message
> news:db60328.0310212233.59ac4b8c@posting.google.co m...[color=green]
> > 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" <bouncer@localhost.not> wrote in message[/color]
> news:<xGdlb.13694$Y1.3780@nwrddc03.gnilink.net>...[color=green][color=darkred]
> > > Wouldn't this question better be asked in an Excel newsgroup? It'll only[/color][/color]
> be[color=green][color=darkred]
> > > a happy happenstance if you find someone here who does this from the[/color][/color]
> Excel[color=green][color=darkred]
> > > side. You'd find people here, perhaps, who control Excel from Access via
> > > automation.
> > >
> > > Larry Linson
> > > Microsoft Access MVP
> > >
> > > "Jenni" <jrobinson@khulisa.com> wrote in message
> > > news:db60328.0310210309.5f608c5f@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[/color][/color][/color]
