OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Openoffice and MS Access

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
mukund
Newbie
Newbie


Joined: 18 Oct 2004
Posts: 2

PostPosted: Mon Oct 18, 2004 4:08 pm    Post subject: Openoffice and MS Access Reply with quote

Can I open databases created in openoffice in MS Access and vice versa. please help.
Back to top
View user's profile Send private message
ftack
Moderator
Moderator


Joined: 27 Jan 2003
Posts: 3102
Location: Belgium

PostPosted: Tue Oct 19, 2004 1:14 am    Post subject: Reply with quote

ODBC is a universal database connectivity client. Using that, you should be able to connect directly to an MS Access database file. Using only Openoffice, you can create databases tables in d-base format, but also eventually in Calc format or CSV format (plain text with deloimiters) (not really recommended for a more 'serious' database. CSV wuold be suited for a database backup or to translate beteween different databases). DBF and CSV can be connected to from MS access using ODBC. The calc format cannot. Consult both your MS Access manual and the OOo help for details on how to connect.
Back to top
View user's profile Send private message
Josť Josephs
General User
General User


Joined: 31 Aug 2004
Posts: 21

PostPosted: Fri Dec 10, 2004 9:05 am    Post subject: Reply with quote

Yes, in dbf format. But the Linux version of OO won't sort (index) your data. The Windows version will sort data (just like Access).
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group