Jim

Thank you, but I am lost.  I need to import an XML into a Pdox table.  I do 
not understand why data from any source is exported to XML - what is the 
advantage of this?  Pity Pdox cant deal with  this.

"Jim Moseley"  wrote in message news:5980b39b$1@pnews.thedbcommunity.com...


Ian,

>I think an import to Excel would be a real mess.

You can save any Excel spreadsheet to an XML format, which is just a text
file.  I've used this to create 'new' Excel files by just replacing the 
formatted
lines with my desired data.

The key is to find the common 'header' and 'footer' text and save that off,
then build your own lines in between:
  Common-Header
  My-Line-1
  My-Line-2
  ...
  My-Line-X
  Common-Footer

Save that entire string as a TextStream, and it can be opened in Excel.

I haven't followed this entire thread, but that is the easiest way I've 
found
to get Paradox data into a formatted Excel spreadsheet.

HTH,
Jim Moseley