OpenOffice Base: Converting data and files from Access
OpenOffice's Base tool provides an open source alternative to proprietary Microsoft Access. But if you need to use both, it's nice to be able to move data back and forth between applications.
In this tip, OpenOffice expert and instructor Solveig Haugland explains how to convert Access files to OpenOffice. She also describes a workaround for changing field orders and discusses how to group items in OpenOffice.
How can you convert Microsoft Access files to OpenOffice Base?
Haugland: You can connect to an Access file in OpenOffice.org. Choose File > New > Database, choose to connect to an existing database, choose Access as the format, and click Next.
In the next window, specify the location of the Access database and follow the wizard through the rest of the windows. Save the database. The name you use will show up in lists of databases, so you can get to the data in the Access database.
Alternately, if you want the data in Access to be in a true OpenOffice.org Base database, then follow the instructions in this article.
How can users group items in OpenOffice's Base the way they did in Microsoft Access?
- Login or register to post comments
- Printer-friendly version
- 2297 reads
- PDF version
More in Tux Machines
- Highlights
- Front Page
- Latest Headlines
- Archive
- Recent comments
- All-Time Popular Stories
- Hot Topics
- New Members
digiKam 7.7.0 is releasedAfter three months of active maintenance and another bug triage, the digiKam team is proud to present version 7.7.0 of its open source digital photo manager. See below the list of most important features coming with this release. |
Dilution and Misuse of the "Linux" Brand
|
Samsung, Red Hat to Work on Linux Drivers for Future TechThe metaverse is expected to uproot system design as we know it, and Samsung is one of many hardware vendors re-imagining data center infrastructure in preparation for a parallel 3D world. Samsung is working on new memory technologies that provide faster bandwidth inside hardware for data to travel between CPUs, storage and other computing resources. The company also announced it was partnering with Red Hat to ensure these technologies have Linux compatibility. |
today's howtos
|
Recent comments
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago
1 year 11 weeks ago