How to create a vbscript to update a table in a database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anoble1
    New Member
    • Jul 2008
    • 246

    How to create a vbscript to update a table in a database

    Is it possible to have a vbscript update to an access database?

    I was thinking of creating a messagebox with the vbscript and have it record in the access database the value which was typed in and the time/date automagically

    Ideas?
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Yes you can.

    You can instantiate an ADODB.Connectio n object in VBS, supply the connection info, and use the Execute method to run a SQL string.

    Comment

    Working...