Convert Excel to XML

Results 1 to 2 of 2

Thread: Convert Excel to XML

  1. #1
    Join Date
    Dec 1969

    Default Convert Excel to XML

    Hi,<BR>we have some excel files and would want to convert all these to XML files. Is there any Sample Code where I can see how this is done. Please point me to the right direction/Suggest. Thanks in advance<BR><BR>Thanks<BR>Bjohn

  2. #2
    Join Date
    Dec 1969

    Default RE: Wrong forum, but...

    ... I do have an answer.<BR><BR>It is possible to open an excel sheet as a database, so with ADODB objects. Then you can use SQL select statements to retreive the data and write some code to make it xml.<BR><BR>I don&#039;t have any example code, but if you google for "excel adodb.connection" I&#039;m sure something handy will come up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts