Sql in Vba macro?

sdk development
1

Hi all…
i want to know, whether it is possible to insert or integrate sql query with vba macro???

If so how to do…

Please help me out to sort out my trouble… :frowning:

(i’m working with Business Objects XI R2… Desktop Intelligence…)

Thanks in advance
Vadivel k

vadivelk (BOB member since 2009-07-28)

2

It is possible to use SQL query in a VBA macro. You will have to define Connection parameters and open up the connection before you execute the query. Go into BOB’s Downloads and take out any relevant DeskI VBA to get an idea.

nithya_raj (BOB member since 2007-02-03)