I am having numerous problems importing a series of XML files to Access 2000. The only way I have found to do it is for Access to launch Excel 2000 open the XML file and work my way along each line picking out the fields between the " " marks.
To speed up this process how can I get Excel to open the files from within Access but not just open them but also apply the " " delimiter so it separates each value into a separate cell?
Any help most appreciated!!
Daline51
To speed up this process how can I get Excel to open the files from within Access but not just open them but also apply the " " delimiter so it separates each value into a separate cell?
Any help most appreciated!!
Daline51
