![]() |
Sql Query
Hello,
I record a New Database Query inside excel, and record macro that runs the query as below. How can I run the Sql Command text without running Open File *.dbq ? Workbooks.OpenDatabase Filename:= _ "G:\Help.dqy", CommandText:=Array( _ "SELECT `ADC_Parts$`.Mfg, `ADC_Parts$`.`Part Number` FROM `G:\ADC Parts`.`ADC_Parts$` `ADC_Parts$` WHERE (`ADC_Parts$`.Mfg='ACC') ORDER BY `ADC_Parts$`.`Part Number`" _ ), CommandType:=xlCmdSql -- Thanks & Best Regards |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com