Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Wizard Long Delay in Excel 2003 ramonvi Setting up and Configuration of Excel 0 November 21st 06 09:37 PM
Query Wizard Cannot Be Used To Edit This Query Carl Excel Discussion (Misc queries) 6 October 17th 06 09:59 PM
Excel Query Wizard Date Format aldsv Excel Discussion (Misc queries) 1 May 31st 05 12:44 PM
"Query cannot be edited by the Query Wizard" PancakeBatter Excel Discussion (Misc queries) 0 April 25th 05 05:59 PM
Question about Query Wizard Anita Excel Discussion (Misc queries) 0 March 7th 05 03:51 PM


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"