Hi I'm a new user of OpenOffice and having trouble opening a Microsoft Database.
I've watch a few Youtube videos on how to do this but keep geting an error
Any help would be great!
Newbie Trying to open MS Access file
Newbie Trying to open MS Access file
OpenOffice 4.1.8 on Window 10
- Hagar Delest
- Moderator
- Posts: 32124
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Newbie Trying to open MS Access file
Hi and welcome to the forum!
What kind of error? If you want us to help you, we need some details.
Please have a look at: Tips for a better description of the problem. The whole tutorial may help by the way. It may have been answered in the past.
What kind of error? If you want us to help you, we need some details.
Please have a look at: Tips for a better description of the problem. The whole tutorial may help by the way. It may have been answered in the past.
LibreOffice 7.5.3.2 on Xubuntu 23.04 and 7.4 portable on Windows 10
Re: Newbie Trying to open MS Access file
MS Access opens MS Access documents only. An MS Acccess doument may embed a MS JET database or it may be connected to a wide variety of external databases.
Base opens Base documents only. A Base doument may embed HSQL database or it may be connected to a wide variety of external databases.
Just like with MS Access, you create a new database document and connect it to some external database.
File>New>Database...
Connect to existing database
Type: MS Access
Specify your Access database
Save the database document.
---------------
Now you an use the MS Access database in the context of this office suite. You can add queries, forms and reports to the database document and you can export database data into OpenOffice documents. The forms and reports that have been created in MS Access are usable with MS Access only.
Base opens Base documents only. A Base doument may embed HSQL database or it may be connected to a wide variety of external databases.
Just like with MS Access, you create a new database document and connect it to some external database.
File>New>Database...
Connect to existing database
Type: MS Access
Specify your Access database
Save the database document.
---------------
Now you an use the MS Access database in the context of this office suite. You can add queries, forms and reports to the database document and you can export database data into OpenOffice documents. The forms and reports that have been created in MS Access are usable with MS Access only.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice