
May 14th, 2004, 08:58 AM
|
|
Contributing User
|
|
Join Date: Nov 2003
Location: Sheffield UK
Posts: 69
Time spent in forums: 1 m 57 sec
Reputation Power: 5
|
|
|
XML and access 97
Hi there,
I've been importing several xml docs into access97 using vba code and the msxmlhttp2 object. I mostly use the getelement by node property of the object.
However I have several very large docs to import (All are obtained from urls) and I was wondering if there was an easy way of bringing them into access97??
I have access to a sql server on the network (sql server 2000) and was considering importing the data onto the sql first then expoting to access using the dts?
Can someone please help me with this?
M3ckon
|