How do I export .mdb file to OpenOffice Base file?

[vincent90152900]

How do I export .mdb file to OpenOffice 3.1 Base file?

The Microsoft Access database file is here.

http://docs.google.com/a/mtschool.o...DItZGU1MC00OGVlLWIwODAtZmU0MzQxNzc1ZDA2&hl=en

 

[Jerry Whittle]

I doubt if you will be able to import the database file itself unless
OpenOffice added a converter since I last checked into it.

You could export all the Access tables as CSV text files and import them
into Base. You could also copy all the SQL statements for the Access queries
into a text document and possibly use them in Base.

Forms, reports, macros, and code won't transfer. Neither will any security
or things like primary keys and relationships.

Basicly you'll just have the data and possibly a way of querying it.

 

[vincent90152900]

Hi Jerry,

Many thanks for replying.

I will try this solution.

Thank you very much.

 

[vincent90152900]

Hi Jerry,

How do I export a table as CSV text file?

Many thanks for your helping.

 

[vincent90152900]

Hi Jerry,

I already solve this problem with a solution below.

From Microsoft Access table to csv file
-------------------------------------------------------------------------------------------------------------------------
Pick your chosen table, query, whatever.
File -- Export...
Using the "Save as type" drop-down arrow, choose "Text Files
(*.txt;*.csv;*.tab;*.asc)"
Give the file a different name if you want to.
Decide if you want it to Save Formatted and if so, do you want Autostart
(not sure about these options, never used them).
Now either use the "Save All" button or "Save" button depending which
you have (if the "Save All" button, you have the choice of "Save All" or
Selected, I think were the options).

Done and no other software involved.

Of course, if it's a database with a lot of tables, etc it might take a
while to do them all but at least you can do it straight out of Access itself
-------------------------------------------------------------------------------------------------------------------------


From csv file to OpenOffice table solution is below

http://sheepdogguides.com/fdb/fdb1imp1.htm

The database I had converted is below.

https://docs.google.com/leaf?id=0B1d8pw ... YmFm&hl=en

Many thanks for your helping.

Many regards,
Vincent