Database :SQLServer
How to execute a file conatining sql commands from vb in
SQlServer?

Read the file into a string and then run the string through a connection.execute call. However, be aware that such dynamic sql is susceptible to sql injection attacks if there is any way to access this file externally.

Yehuda

Hi,

You can copy the SQL statements in a text file and then can execute the SQL statements through VB by using FileSystemObject.

Keep on concatenating the SQL statements in a string and when you find the GO statement just execute the string through Recordset object in VB.

Hope this helps,

Lalit
Life Means More...;)