XML and Access

[paul@geotas.nl]

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("A fasGetConnector .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

[DFS]

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("A fasGetConnector .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).aspx

http://support.microsoft.com/kb/269238