Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
read only and write only | New Users to Excel | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
Read/Write | Excel Programming | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
write to/read from add-ins | Excel Programming |