RE: microsoft query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Jenn,

I don't think you have removed the Query since this query feature is
part of the office suite and not part of the third party tools (Analyser,
etc...), to ensure you have it, with your workbook excel opened, try
motivating to Data menu > Import External Data > New Database Query > MS
Access Database > then locate your database or external source...

Hope this helps,
Adnan



"jenn" wrote:

I no longer needed my microsoft query analyzer program. In removing it I may
have also removed the microsoft query that allows my Excel 2007 to query my
SQL Database.

How to I reinstall the microsoft query tool in Excel?
.

Relevant Pages

  • RE: (Excel 2007) Query Data in Database?
    ... are both headers of the Sheet in Excel, ... Is the ADDRESS field to much for the Microsoft Jet database engine? ... When you do a query you should be selecting the columns You want to ... the sort has to be one of these columns. ...
    (microsoft.public.excel.programming)
  • Re: Excel Access interface
    ... You could create a 'stored procedure' in the database. ... > You can create an External Data table in Excel that uses a parameter query. ... > prompt you to input values for each parameter that you entered. ...
    (microsoft.public.excel.programming)
  • To use parameter with like.
    ... I am attempting to establish a parameter in Excel containing a wildcard ... Wildcard Character Placement in MS Query ... I tested my posted LIKE clause using MS Query against an MS Access database. ...
    (microsoft.public.excel.programming)
  • Re: Split database into smaller db based on values
    ... Why have the Excel file "query the database"? ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.modulesdaovba)
  • Re: How can I change the source of my extern source database in an
    ... Excel Blog - Daily Dose of Excel ... >>> that if he uses the query's he has to select an external database, ... >>>> click the edit query icon. ...
    (microsoft.public.excel.programming)