VBA 怎样执行多个SQL语句
VBA 怎样执行多个SQL语句
日期:2018-04-12 22:58:27 人气:1
Dim conn as New SqlConnection(连接字符串)
Dim cmd as new sqlcommand
cmd.CommandType = Text 或者SqlProcedure
cmd.Connection = conn
cmd.TimeOut= 30
cmd.CommandText = "Update ........." 或者 "Select ..... "
'' 用来执行操作用这个
cmd.Exec