Query Editor question
 

My questions to Microsoft a
Has Microsoft Query editor (in Excel 2007) been updated to directly
interchange SQL (text) code with MS Access. Currently the direct text SQL
coding format is different between the two products. I would like to be able
to cut SQL text from a MS Access Query and paste it directly into MS Query
(Excel), and it work. See two examples below:

From MS Query (in Excel 2003):
SELECT FSOdata.CCN, FSOdata.MASLOC, FSOdata.CUSTOMER, FSOdata.MACHINE,
FSOdata.FSO, FSOdata.FSO_LINE, FSOdata.CALL_DATE, FSOdata.SVC_DATE,
FSOdata.INV_DATE, FSOdata.INV, FSOdata.ITEM, FSOdata.DESCRIPTION,
FSOdata.QTY, FSOdata.AGC, FSOdata.CURRENCY, FSOdata.EXT_COST,
FSOdata.EXT_INV, FSOdata.FSA_ID, FSOdata.PO, FSOdata.FSE_ID
FROM ACLSFSO.dbo.FSOdata FSOdata
WHERE (FSOdata.MASLOC='RIC') AND (FSOdata.FSO_LINE Like '%c') AND
(FSOdata.INV_DATE{ts '2007-01-01 00:00:00'})

From MS Access 2003:
SELECT dbo_FSOdata.CCN, dbo_FSOdata.MASLOC, dbo_FSOdata.CUSTOMER,
dbo_FSOdata.MACHINE, dbo_FSOdata.FSO, dbo_FSOdata.FSO_LINE,
dbo_FSOdata.INV_DATE, dbo_FSOdata.ITEM, dbo_FSOdata.DESCRIPTION,
dbo_FSOdata.QTY, dbo_FSOdata.AGC, dbo_FSOdata.CURRENCY, dbo_FSOdata.EXT_COST,
dbo_FSOdata.EXT_INV, dbo_FSOdata.FSA_ID, dbo_FSOdata.PO, dbo_FSOdata.FSE_ID
FROM dbo_FSOdata
WHERE (((dbo_FSOdata.MASLOC)="RIC") AND ((dbo_FSOdata.FSO_LINE) Like "*c")
AND ((dbo_FSOdata.INV_DATE)#1/1/2007#));