| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import New Database Query (Union Query) in Spreadsheet
I have been using Import New Databse Query to update information from Access
to Excel. It works great for all table queries except Union Queries. I get the error - "Too few parameters. Expected 1." How can I get around this with still using a Union Query? Thanks for any feedback |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import New Database Query (Union Query) in Spreadsheet
Instead of pulling the parameters in Access , you should create them in Excel
Microsoft Query. -- Alex *Remember to click "yes" if this post helped you. Thank you! "klock" wrote: I have been using Import New Databse Query to update information from Access to Excel. It works great for all table queries except Union Queries. I get the error - "Too few parameters. Expected 1." How can I get around this with still using a Union Query? Thanks for any feedback |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Import New Database Query (Union Query) in Spreadsheet
Alex - Thank you for your reply. How do I create in Excel 2003?
"alexrs2k" wrote: Instead of pulling the parameters in Access , you should create them in Excel Microsoft Query. -- Alex *Remember to click "yes" if this post helped you. Thank you! "klock" wrote: I have been using Import New Databse Query to update information from Access to Excel. It works great for all table queries except Union Queries. I get the error - "Too few parameters. Expected 1." How can I get around this with still using a Union Query? Thanks for any feedback |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import database query that has a date range | Excel Discussion (Misc queries) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| Database query to import from Access to Excel | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
