Importing data from multiple Access queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
ans = InputBox("Enter Parameter")

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

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