|Subject:||Re:Importing XML files using ODBC
|Date:||Fri, 25 Aug 2017 11:17:11 +0200 (GMT+02:00)
Hi, I know I am a bit late, sorry.
I use Excel to open XML files, and import the data from Excel.
Works well if you have a flat table in your XML file.
I wrote an Objectpal routine to import the Excel file and analyse
the field datatype and size.
Let me know, if you are interested in the sourcecode
"Ian Espie" <email@example.com> Wrote in message:
> Dear Pdox friends,
> I am faced with a new challenge and that is to import XML files into Pdox11.
> M$ Access does it well and export to Pdox.db also works well, but all the
> fields are text with size 255. I can work around this problem. But what I
> would like to do is to setup a ODBC to import the XML data into Pdox using
> code. Surely by now there is a M$ ODBC driver to do this, but I cant seem
> to find one. I have also looked through all the older threads on XML, but
> also cant find what I need.
> Perhaps someone has some new information on how to do this? I would greatly
> appreciate any help.
> Cheers for now.
> Pdox diehard.
----Android NewsGroup Reader----