Importing data from multiple Access queries

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?
 
G

Guest

ans = InputBox("Enter Parameter")

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query from Excel to Access - Passing Parameters? 8
Best way to get data from Access 2003 to Excel 2003 6
Import data from multiple files 3
Using data from cells in a Query to a MS Access Database 2
import data with microsoft query 1
What is the wild card for an Access query (MS query) parameter? 2
Can I pass the logon credentials in a macro to a ODBC query 1
Database import 3

Top