ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cannot get Query Wizard to work in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/173912-cannot-get-query-wizard-work-excel.html)

Seamus O'Connell

Cannot get Query Wizard to work in Excel
 
Apologies if I have posted this twice. I think it failed the first time but
I'm not sure. Anyway I couldn't find the question in the discussion group.

It's likely that my problem arises from basic misunderstanding of how things
work, but I would be very grateful for help.

I've got Office Professional 2003 under XP Home + SP2 and I subscribe to the
MS automatic software update service.

I'm trying to use Query Wizard to set up a query to transfer selected rows
from an Access database to an Excel worksheet.

In Excel I do < Data / Import External Data / New Database Query / Databases
/ MS Access Database* / Browse but I can't see my database. Its folder is
in the top slot but no files are shown below it. < Files of type shows <
data sources .

Perhaps I have not got Query installed for Excel (it is installed for Access
and I have used it there). But I don't get prompted to install Query when
doing the above operation.

I tried to find out if Excel had got Query installed via Add or Remove
Programs (in my administrator account with my user accounts closed). I
selected MS Office change and got a window asking me to select applications
to install and deselect applications to remove, but I don't want to do
either. I want to find out what's there.

How can I find out the installation details for Excel, and other Office
programs?

--
Seamus O'Connell


All times are GMT +1. The time now is 02:30 PM.

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