ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Get External Data from Access Parameter Query (https://www.excelbanter.com/excel-discussion-misc-queries/168063-get-external-data-access-parameter-query.html)

newuser

Get External Data from Access Parameter Query
 
I am trying to use an MS Access parameter query as the data source in Excel's
"Get External Data" functionality. When I set this up and then try to
refresh data on the Excel worksheet I get a warning message, "Too few
parameters; expected 2". I can't figure out how to enter the parameters when
I am in the Excel worksheet trying to refresh the data. Is this possible?
(I work with Excel 2000)
--
JB


All times are GMT +1. The time now is 05:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com