Skip to content

Instantly share code, notes, and snippets.

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

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

Select an option

Save cx20/2905711 to your computer and use it in GitHub Desktop.
Hello, ACE Database World! (VBScript + ADO + OLEDB + ACE)
Set cn = CreateObject("ADODB.Connection")
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=Hello.accdb"
Set rs = cn.Execute("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