Siax
12 years agoContributor
ADO Help
In the Documentation: http://support.smartbear.com/viewarticle/28454/ it states that you can use :It can be used to execute only SQL queries ( SELECT, UPDATE, INSERT , etc.), But I can't ...
sub sqlCommand()
dim connection 'the ADO connection object.
dim cmd 'the Command object.
'set up the connection to the database.
set connection = ADO.CreateConnection'specify your SQL database connection string.
connection.ConnectionString = "<your connection string here>"
connection.Open
'create and specify the SQL command to execute.
set cmd = ADO.CreateCommand
cmd.ActiveConnection = connection
cmd.CommandText = "<your SQL command here>"
cmd.CommandType = adCmdText
'execute the command.
cmd.Execute()
end sub