Thread: microsoft query
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Greenwind Greenwind is offline
external usenet poster
 
Posts: 16
Default SQL in Microsoft Query or Independent Microsoft SQL

I'm sure this is too basic for a lot of you. Perhaps a bit silly.

I have a Excel file and I'd like to 1) to change the format of one column in
the Excel file. For example, to change 31 Jan 88 to 31/01/1998. (I've tried
to change this in Excel but I can't). 2) still in Excel, to compare the
content of two columns (A and C) and to fill a third column's (C) content
into a new column (D). For example, Column A is 31 Dec 2001. Although 31 Dec
2001 is a date, 31 Dec 2001 actually means the period from 01 Dec 2001 to 31
Dec 2001. Both dates, 01 Dec 2001 and 31 Dec 2001, are included. Column B has
the amount of debt in sterling pounds (3.1124) in corresponding to column B.
Column C shows the issuing dates of the debt (31 Dec 2001). Because 31 Dec
2001 is within the period of 01 Dec 2001 and 31 Dec 2001 in column A, the
content of column B (3.1124) is put into column D.

Do you think that I can achieve above by writing a small program in the SQL
window within Microsoft Query? Or I have to have the software Microsoft SQL
Server 2000 :Developer Edition and a server to do this?

If I can do this in Microsoft Query, how can I link my Excel file (say
named: handling) to Microsoft Query in order to write SQL, please?

Thank you so much!


"jenn" wrote:

When I do this is tells me all my tables are empty... yet, I can use the
other option of 'import data from unlisted source'.. then select ODBC and my
tables are there.

"Adnan" wrote:

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?