ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sql Query (https://www.excelbanter.com/excel-programming/346795-sql-query.html)

LeeL

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