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