Can you provide some more information as to what's happening, or not
happening, and what your setup is? Are you attempting to put the data into
an external data range, or directly into a pivot table? Are all the tables
in the same Access database? What's happening, or not happening, when the
wizard "will not allow me to move on"? An error message? A disabled OK
button? Something else?
Meantime, you might try running MS Query without using the Query Wizard
(clear the "Use the Query Wizard to create/edit queries" checkbox first).
This tends to give you more control over what's going on.
--
C^2
Conrad Carlberg
Excel Sales Forecasting for Dummies, Wiley, 2005
"TrevorM" wrote in message
...
Hi
I am using MS Query to extract data from an Access Database which runs
queries from ODBC linked data tables.
In the Database the queries run perfectly and I have no problem, but if I
try extract data from these queries, the query name is visible in the MS
query wizard window but it will not allow me to move on through the
wizard.
I would appreciate your feedback
|