Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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#)); |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query question | Excel Worksheet Functions | |||
Web Query question | Excel Discussion (Misc queries) | |||
Web Query Question | Excel Discussion (Misc queries) | |||
Microsoft Query editor opens but does not display in excel. | Excel Discussion (Misc queries) | |||
query criteria question | Excel Discussion (Misc queries) |