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
"vincent90152900" wrote:
> Hi Jerry,
>
> How do I export a table as CSV text file?
>
> Many thanks for your helping.
>
> "Jerry Whittle" wrote:
>
> > 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.
> > --
> > Jerry Whittle, Microsoft Access MVP
> > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> >
> >
> > "vincent90152900" wrote:
> >
> > > 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.or...Nzc1ZDA2&hl=en
> > >
> > >
Similar Threads
