Paradox Community

Items in pnews.paradox-programming

Subject:Re:Importing XML files using ODBC
Date:Fri, 25 Aug 2017 11:17:11 +0200 (GMT+02:00)
From:thies <thies.grimm@t-online.de>
Newsgroups:pnews.paradox-programming
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 
Thies


-- 


"Ian Espie" <ianespie@mweb.co.za> 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.
> 
> Ian. 
> 
> 


----Android NewsGroup Reader----
http://usenet.sinaapp.com/


Copyright © 2004 thedbcommunity.com