XML and Access

Hi,

I'm developing a new application. The datasource for the application
is generating a string filled with XML data.
Because we need all record we need to split this XML data.
When we save the XML data to disk and then import this into access
it's working fine but we want to skip the save to disk /import part
(performance)
Who can tell me how to do this ?

Currente code :

Dim objGetConnector As Object
Dim strOutput As String
Set objGetConnector = CreateObject("AfasGetConnector.Main")
objGetConnector.Logon "demo", "user", "password"
strOutput = objGetConnector.Execute("adres", 1, , , 1)

strOutput is filled with a XML file and we must have this in a table

Thanks,

Paul

Re: XML and Access

paul@geotas.nl wrote:
> Hi,
>
> I'm developing a new application. The datasource for the application
> is generating a string filled with XML data.
>
> Because we need all record we need to split this XML data.
> When we save the XML data to disk and then import this into access
> it's working fine but we want to skip the save to disk /import part
> (performance)
>
> Who can tell me how to do this ?
>
> Currente code :
>
> Dim objGetConnector As Object
> Dim strOutput As String
> Set objGetConnector = CreateObject("AfasGetConnector.Main")
> objGetConnector.Logon "demo", "user", "password"
> strOutput = objGetConnector.Execute("adres", 1, , , 1)
>
> strOutput is filled with a XML file and we must have this in a table

Tools | References | Microsoft XML, v6.0

http://msdn2.microsoft.com/en-us/library/ms753804(VS.85).asp x
http://support.microsoft.com/kb/269238