How do I insert to sql server

[adamscentral92]

How do I insert a field into sql server in vb script. Can someone put
in an example?

Thanks,
AC92

 

[Cor Ligthert [MVP]]

AC,

This is not a vb scripting newsgroup, however you need at least the SQL
command.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_3ied.asp

I hope this helps sofar,

Cor

 

[andy]

Something along the lines of

Dim cn
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=sqloledb;Data Source=Server;Initial
Catalog=YourDatabase;User Id=Login;Password=blaa;"
'or, trusted connection (NT authentication)
cn.Open "Provider=sqloledb;Data Source=Server;Initial
Catalog=YourDatabase;Integrated Security=SSPI;"

dim i

Set i = cn.Execute "ALTER table as per cor's link"