Skip to content

Instantly share code, notes, and snippets.

@cx20
Created June 10, 2012 13:48
Show Gist options
  • Select an option

  • Save cx20/2905708 to your computer and use it in GitHub Desktop.

Select an option

Save cx20/2905708 to your computer and use it in GitHub Desktop.
Hello, ACE Database World! (VBScript + DAO + ACE)
Set dbe = CreateObject("DAO.DBEngine.120")
Set db = dbe.OpenDatabase("Hello.accdb")
Set rs = db.OpenRecordset("SELECT 'Hello, ACE Database World!' AS Message")
WScript.Echo rs(0).Name
WScript.Echo "--------------------------"
WScript.Echo rs(0).Value
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment