Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Query in Microsoft Excel
Hi Sir,
I encounter some difficulty that need so enlightment. I can run the SQL Query but i find it hard to do editing to the existing query in Excel. So i went to look at how programming can be done: Workbooks.OpenDatabase Filename:= _ "G:\Asia\Product\Operations\MolexStockReport\Q uery from Excel Files.dqy", _ CommandText:=Array( _ "SELECT ADC_Parts.Mfg, ADC_Parts.`Mfg Part Number`, ADC_Parts.`On Hand` FROM `G:\Asia\Product\ADC Part Di\ADC Parts`.ADC_Parts ADC_Parts WHERE (ADC_Parts.Mfg='MOL') AND (ADC_Parts.`On Hand`0) ORDER BY ADC_Parts.`Mfg Part Number" _ , "`"), CommandType:=xlCmdSql however, i do not really understand what is this SQL all abt? Is there other aleternative to use other than using SQL to filter data array to obtain what i want using macro? Waiting for soonestyour reply, Junior |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Query in Excel | Excel Discussion (Misc queries) | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
Need help with Excel Microsoft Query | Excel Discussion (Misc queries) | |||
Microsoft query in Excel | Excel Discussion (Misc queries) | |||
Excel Microsoft query | Excel Discussion (Misc queries) |