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