Link to home
Start Free TrialLog in
Avatar of diegohugo
diegohugo

asked on

Bulk Sql sentecences execute from Vb6 project

Hello Experts
I would like to know how can I process and text file with undreds of lines containing SQL Sentences
Do I have to go line by line assigning each line to a string variable and executing it? or is there any other way to launch it all together
thanks
Avatar of TDSnet
TDSnet

Hi,

There might be a way to create a Stored Procedure using the commands from the text file but you're still going to have to iterate through the file to extract each command so it might be just as easy to just go through executing each line at a time.

Cheers,
Jack
ASKER CERTIFIED SOLUTION
Avatar of Shiju S
Shiju S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial