Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to perform SQL INSERT from vbs script
Woops, I forgot a question in my last post.
http://www.activexperts.com/activmon...soffice/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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to perform SQL INSERT from vbs script
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. "Siegfried Heintze" wrote: Woops, I forgot a question in my last post. http://www.activexperts.com/activmon...soffice/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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Script to insert Row | Excel Discussion (Misc queries) | |||
Need VBA script to auto-insert value upon row insert | Excel Worksheet Functions | |||
Insert a key function in VBA script | Excel Programming | |||
Script to insert the next Friday | Excel Programming | |||
Script to insert the next Friday | Excel Programming |