How to perform SQL INSERT from vbs script

[Siegfried Heintze]

Woops, I forgot a question in my last post.

http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/
has a great little VBS script. I tried to enhance it to perform an SQL
insert statement. See my other recent post for the listing that includes my
attempt on lines 33-38. It did not work. No error message!

Can I expect SQL INSERT/DELETE/UDPATE statements to work with Excel?

Thanks,
Siegfried

 

[NateBuckley]

The following SQL statement works for me and is an insert

strSQL = "INSERT INTO tblEmployees [fldClockNo], [fldName] VALUES '" &
ClockNo & "', '" & name & "'"

Quite hard to make out the single quote characters but that works.