| View previous topic :: View next topic |
| Author |
Message |
nicoadamo Newbie

Joined: 01 Aug 2010 Posts: 2
|
Posted: Sun Aug 01, 2010 2:14 pm Post subject: open / load / import a dbf sheet into a .ods file (Calc) |
|
|
Hi! Is there any easy macro code to do that? I tried some code suggested in some posts, but although they work well for opening ods files, they do nothing for dbase files.
I tried a macro from this forums that displays the filters used and it returned "IBMPC_850" for the dbf I want to load. If it helps, I'm with OpenOffice 3.2 on windows mostly, although I don't see why it should be different under linux since Oo.org works under the multiplatform Java.
Thanks in advance,
Nicolás |
|
| Back to top |
|
 |
pitonyak Administrator


Joined: 09 Mar 2004 Posts: 3618 Location: Columbus, Ohio, USA
|
Posted: Sun Aug 01, 2010 2:41 pm Post subject: |
|
|
If you are able to use the GUI to do this, then you should also be able to write a macro that will open the file and read it into a single sheet. I have done much of this sort of thing, but, it has been a very long time.
Take a quick look at this document to see if it helps:
http://www.pitonyak.org/database/AndrewBase.odt _________________ --
Andrew Pitonyak
http://www.pitonyak.org/oo.php |
|
| Back to top |
|
 |
nicoadamo Newbie

Joined: 01 Aug 2010 Posts: 2
|
Posted: Sun Aug 01, 2010 2:47 pm Post subject: |
|
|
Thank you Mr. Pitonyak for your reply! I'll read that file. But if someone knows the code I asked, its always welcome  |
|
| Back to top |
|
 |
|