Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Complex query of Access DB in Excel

Status
Not open for further replies.
rgreen511

rgreen511

Technical User
Aug 22, 2005
24
US
I've read some similar posts, but nothing with this unique problem.

I'm trying to Query data into Excel from a Query that exists in Access. In the Excel query setup, the Access Query is showing up as a table, which is fine. However, the Access query requires a date input, which is normally given using an Access Form when the query is run within Access. When I try to run the query in Excel I get "Too few parameters. Expected 1."

How can I pass a date from Excel to Access in order to satisfy the needed parameter and successfully run this query of a query?

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
3K
OCM
OCM
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
831
dhookom
dhookom
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
736
renigar
renigar
renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
3K
Andrzejek
Andrzejek
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
4K
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top