Ask the Expert

Converting Access files to OpenOffice

Can I convert Access files to OpenOffice for use on a one-time basis?

    Requires Free Membership to View

You can connect to an Access file in 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 Base database, then follow the instructions in this article.

This was first published in November 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: