Importing data from multiple Access queries
 

I am trying to import data into excel from Access from multiple queries based
on 2 parameters. I can create a macro to import the data, but I only want the
user to be prompted one time for the input, instead of a seperate prompt for
each query. Is there any way to use a input box to pass that input to each
query in MS query for instance?

Importing data from multiple Access queries
 

ans = InputBox("Enter Parameter")

then in your query string, concatenate in the value of Ans

"firstPart of query " & ans & " another part of the query" . . .

--
Regards,
Tom Ogilvy


"JoeA2006" wrote:

I am trying to import data into excel from Access from multiple queries based
on 2 parameters. I can create a macro to import the data, but I only want the
user to be prompted one time for the input, instead of a seperate prompt for
each query. Is there any way to use a input box to pass that input to each
query in MS query for instance?