running long sql in VB

nn992

New Member
Joined
Jul 28, 2016
Messages
47
Hi,
I am trying to run multiple lines sql code within VB, but I dont know how to separate/concatenate the code....

part of my code is:

Code:
vSql = "

with AAA as(select BBB,CCC from DDD
where ( EEE as 'XX%' or FFF like 'YY%')
"
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
what is your current working SQL
 

Watch MrExcel Video

Forum statistics

Threads
1,109,275
Messages
5,527,728
Members
409,785
Latest member
AdamPriest

This Week's Hot Topics

Top