[AccessD] XML Import Sample File

Greg,

I did try sample code with MSXML 6.0 and it worked OK.

Try to debug/trace this function:

My guess the problem is in this function:

Public Function Parse(ByVal vstrURL As String, ByVal vstrTableName As
String, ByVal vavarFields As Variant)
Dim reader As SAXXMLReader40
    mavarFields = vavarFields
    mstrTableName = vstrTableName
    mintFieldIndex = -1
    mintFieldsCount = 0
    Set reader = New SAXXMLReader40
    Set reader.contentHandler = Me
    Set reader.errorHandler = Me
    reader.parseURL vstrURL
End Function

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Greg Smith
Sent: Tuesday, November 28, 2006 12:54 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] [Access-D] XML Import Sample File

Hi Shamil:

I'm currently set at MSXML 6 (MSXML6.dll).

Greg

> Hello Greg,
>
> Try to change reference to MSXML v.4.0 or above....
>
> --
> Shamil
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> gwsmith at iowatelecom.net
> Sent: Monday, November 27, 2006 8:41 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] XML Import Sample File
>
> Shamil:
>
> Thanks again for the sample file code, by the way.
>
> The first two functions, XmlImportTest1() and XmlImportTest2() both work
> just fine.  However, when I try to test XmlImportTest3() or
> XmlImportTest4(), I get the following error:
>
>   Run Time Error '429'
>   Active X Component Can't Create Object
>
> and the following line of code is highlighted as the culprit:
>
>   obj.ImportData CurrentDb, "Shippers", Array _
>     ("CompanyName", "Phone"), mcstrXml1FullPath2
>
> where ...FullPath1 is for ...Test3() and ...FullPath2 is for ...Test4().
>
> I have the sneaky feeling I don't have something installed or properly
> referenced, but I'm not sure what.
>
> Any suggestions?
>
> Thanks!
>
> Greg Smith
>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com