Skip to Content
0
Former Member
Jul 12, 2006 at 08:03 AM

How to use the function EXEC_SQLCMD_MSQ in Excel?

79 Views

Hi Friends,

can anyone explain how to use use this function EXEC_SQLCMD_MSQ in Excel to get the result.

I have written excel macro to use this function, statement like "Select * from t001" but the function doesn't reply any value.

My objective is to pass the (any, generalised)

sql statment to this function and get the result in Excel file.

Please give the solution for this.

Thanks

Shankar