Import internet explorer content into access table

[DALIEN51]

Hi,

Is it possible to open a XML file in Internet Explorer create a DDE link and read the content in row by row to an Access table? I am using MS Access 2000.

I have started with the following which works so far and establishes the DDE connection - but how do I actually read in the content? I am assuming it is a DDEREQUEST command but I dont know the exact syntax.

Dim intChan1 As Long
Dim myURL As String

myURL = "c:\output.xml"

Shell ("c:\program files\internet explorer\iexplore.exe " & myURL), vbMinimizedNoFocus
intChan1 = DDEInitiate("Iexplore", "System")

 

[DannySeager]

Do you need to use internet explorer?

Have you considered using the MSXML straight from VBA?

 

[NigelShaw]

Hi

here are some links for Access options to communicate with the internet

http://msdn.microsoft.com/en-us/library/aa385096(VS.85).aspx
http://msdn.microsoft.com/en-us/library/aa384363(VS.85).aspx
http://msdn.microsoft.com/en-us/library/aa384233(VS.85).aspx
http://msdn.microsoft.com/en-us/library/aa384247(VS.85).aspx
http://msdn.microsoft.com/en-us/library/aa385103(VS.85).aspx

they are in order. it took me a whole night to get my head into it but now i find it really useful.

i have an asp site at work that provides callbacks via internet pages. no, i can collect the data direct from my access by reading the string returns without having to open the pages and write everything down


regs

Nigel