translate xls to xml

  • Thread starter Thread starter Bruno
  • Start date Start date
B

Bruno

Hi

I have excel file and I used xml database.The problem is that I would
transfered all data of excel files in my db.
It's possible but I don't know how.

Thanks
 
But it's in vb.net program who the entry file is xls file and this program
work with a database xml( type dataset).
 
Nevermind him <G>

I've accomplished what you need by adding a reference to the Excel COM
objects. Then use the COM objects to pull data from the various cells. From
there it's just a matter of deciding where in your xml database to put the
data.
 
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it
to your XML file.
 
Top Answer.

Sometimes ( but not often ) even I get carried away with redirecting
questions.

Regards OHM
 
Thanks lot,
i try it now

Jeff Molby said:
Even better idea... I bet you can use the OleDbDataAdapter to open the
spreadsheet and fill a dataset. From there, it's a piece of cake to save it
to your XML file.
 
Back
Top