So I'll start by saying I'm very new to programming VB Scripts...
Anyways, I'm trying to program an API for my company.
I start by creating an HTML pages which POSTs my login data to a webpags. The POST call returns a database in XML.
I am trying to import this XML database into Access with the following code:
-
'initialize Access Database and import data from Blue Hornet
-
'Dim appAccess As New Access.Application
-
appAccess.OpenCurrentDatabase strDb
-
-
appAccess.DoCmd.OpenTable "Opt Outs"
-
-
appAccess.ImportXML _
-
Datasource:="xxx.html", _
-
ImportOptions:=acStructureAndData
-
I am getting the following error:
-
Microsoft VBScript compilation error '800a0400'
-
-
Expected statement
-
-
/API/OptOut_API.asp, line 19
-
-
Datasource:="xxx.html", _
-
-----------^
-
Can someone help me please??
