Read/Write to OpenOffice
Is it possible to use MS Excel with ADO.net to read/write from/to an
OpenOffice database (.odb file)? Thanks |
Read/Write to OpenOffice
The ODB extension is a text file in XML format so you should be able to read the file just like a XML file. Try renaming the file to an XML file extension and see if that works if you can't just read the file directlyby selecting *.* and opening the file. I haven't done it before. You may have to strip off the header and trailer portion of the file becuase the XML may not recognize some of the tags that are used in the header. You can do a web search to find examples of reading XML files using VBA. There have been numerous request for read XML in VBA. If you can't find what you are looking for I can help. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160601 Microsoft Office Help |
All times are GMT +1. The time now is 10:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com