Re: msQuery: is JOIN command possible in Excel?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

AFAIK MSQuery does not support a UNION.

NickHK

"sharon" <sharon_scott@xxxxxxx> wrote in message
news:CEEB9CB3-692E-43CA-AEF1-09147097D0A3@xxxxxxxxxxxxxxxx
I am writting a SQL sentence in msQuery and it says "Impossible to add
(SELECT table", in the next sentence:

SELECT id_User,id_PC,vTime FROM (SELECT 1 AS PC_new.id_User
`c:\PC_office`\PC_new.DBF PC_new UNION ALL SELECT 2 AS PC_old.id_User
`c:\PC_office`\PC_old.DBF PC_old)
WHERE id_User Like 'TED%'

Is it possible to do in Excel? What's wrong in my sentence?
Any idea?




.

Relevant Pages

  • If youre still interested...
    ... When calling the code below we get an Exception "Exception from HRESULT: ... call any Excel COM methods so it must be in this code.) ... values in the UDF definition, the error "800A03EC" will be thrown. ... Microsoft Online Community Support ...
    (microsoft.public.office.developer.com.add_ins)
  • RE: Excel Web Access Error
    ... Do I need to escalate it as a support incident or something please? ... Subject: Excel Web Access Error ... WIndows Server 2003 R2 Standard Edition, do you think that this may explain ... Thread-Topic: Excel Web Access Error ...
    (microsoft.public.sharepoint.portalserver.development)
  • RE: Excel Calculation is faster when visible than when Visible=Fal
    ... The spreadsheet recalculates faster after successive data imports. ... With successive data imports into the same excel instance the ... By the 3rd data import recalculation is nearly ... Services via telephone so that a dedicated Support Professional can ...
    (microsoft.public.excel.programming)
  • Re: Import from Excel and Create Date into the SharePoint Default "Created" field
    ... I'd also think it would be useful to know if he is asking about Excel 2003 or 2007 ... ... Everything you need to know about Microsoft Office SharePoint Server Event Handlers. ... We welcome your comments and suggestions about how we can improve the support we provide to you. ... The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: What is the Excel equivilent of...
    ... to be used to preserve macro settings in between macro sessions. ... In Excel, we do not have the similar session issue. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.office.developer.com.add_ins)