help with ImportXML method

[akay]

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??

[MMcCarthy]

As the problem is with the Datasource try posting on the XML forum as well for help.

[MMcCarthy]

Also check out these links. I'm no expert but I think your datasource has to have an xml extension.

[color=#800080]http://www.oreillynet. com/pub/wlg/6937[/color]

[color=#800080]http://databasejournal .com/features/msaccess/article.php/3310901[/color]