| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.access,microsoft.public.excel.programming
|
|||
|
|||
Acess Queries, Parameters and VBA Problem
Here is my problem.
I am trying to query a query held in Access 2003 from Microsoft Excel. I have done this successfully using VBA. The problem is that I dont want the access query to contain ALL the data so I need to use criteria ( Where Clause ). This is ok except for the fact that the ODBC Driver returns an error telling me it requires a number of parameters. Any ideas on how to get around this |
|
#2
Posted to microsoft.public.access,microsoft.public.excel.programming
|
|||
|
|||
|
Acess Queries, Parameters and VBA Problem
Answered in another thread in this newsgroup. (Subject 'Getting Access Query
Data Into Excel Using VBA'). -- Brendan Reynolds Access MVP "Goofy" wrote in message ... Here is my problem. I am trying to query a query held in Access 2003 from Microsoft Excel. I have done this successfully using VBA. The problem is that I dont want the access query to contain ALL the data so I need to use criteria ( Where Clause ). This is ok except for the fact that the ODBC Driver returns an error telling me it requires a number of parameters. Any ideas on how to get around this |
|
#3
Posted to microsoft.public.access,microsoft.public.excel.programming
|
|||
|
|||
|
Acess Queries, Parameters and VBA Problem
How are you currently returning the data to Excel ?
NickHK "Goofy" wrote in message ... Here is my problem. I am trying to query a query held in Access 2003 from Microsoft Excel. I have done this successfully using VBA. The problem is that I dont want the access query to contain ALL the data so I need to use criteria ( Where Clause ). This is ok except for the fact that the ODBC Driver returns an error telling me it requires a number of parameters. Any ideas on how to get around this |
|
#4
Posted to microsoft.public.access,microsoft.public.excel.programming
|
|||
|
|||
|
Acess Queries, Parameters and VBA Problem
Maybe ?
http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Goofy" wrote in message ... Here is my problem. I am trying to query a query held in Access 2003 from Microsoft Excel. I have done this successfully using VBA. The problem is that I dont want the access query to contain ALL the data so I need to use criteria ( Where Clause ). This is ok except for the fact that the ODBC Driver returns an error telling me it requires a number of parameters. Any ideas on how to get around this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parameters In External ODBC Data Queries - "is one of" | Excel Discussion (Misc queries) | |||
| Excel web queries using parameters | Excel Discussion (Misc queries) | |||
| Excel Queries with subqueries and parameters | Excel Discussion (Misc queries) | |||
| parameters not allowed in queries that can't be displayed graphica | Excel Programming | |||
| Parameters are not allowed in queries that can't be displayed grap | Excel Discussion (Misc queries) | |||
Linear Mode
