Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Re: Read XML files into Access Tables [Thread Next] Re: Read XML files into Access TablesTo: NULL Date: 7/2/2006 10:31:00 PM The XLM files are land survey files. Sample XML files can be downloaded from... http://www.landxml.org/LandXMLSamplesDemos.aspx Access has an IMPORT XML routine, but it does not use the XSD listed in the XML file. The Access tables always get truncated, and aborts importing. I have to figure out the VB code for a module, using MSXLM to... (1) read the XLM files into tables (2) allow the user to add/edit survey points and lines, cross sections, map symbols and etc. from various other survey formats. (3) write back the revisons/updates to the XML format. I can't do #2, and figure if I can understand how to do #1 then #3 would be just and update of the XML document. I wrote several parsers in VB, but the nodes and elements are so complex, I can't perdict all the cases, and an error eventually comes up when optional items are omitted or when a node is not programmed. -- hgeron "Gadrin@g..." wrote: > what format are the XML files in ? are they ADO persisted recordsets ? > > > or something else ? > > you might be better served by hitting the Microsoft Website and > searching there for the format you're using. > > I've seen a detailed article on ADO's persisted recordsets and how > they're put together. > I've only have Access 2002 so I haven't looked at any other XML formats > for Access. > > Gadrin > > > hgeron wrote: > > I am new to XML, but have used Access and VB for a long time. > > I thought if I read the MSXML documentation I could figure > > out how to get the data from the XML, but the more I read > > the worse it gets. The XML files are very complex. > > > > Can someone provide an example that loads an XML file > > into the DOM and walks thru the nodes, elements, and attributes > > in VB that works with Access Modules, Subs, functions etc? > > > > A sample or a URL to help will be appreciated. > > > > -- > > hgeron > > | ||||||
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site | |||
|
