[Solved] Convert Base to MS Access

Discuss the database features

[Solved] Convert Base to MS Access

Postby Zylstra555 » Sun Jan 27, 2008 10:47 pm

I am at my wits end, it seems impossible to do!
I cannot convert my Base documents to MS Access, or to Calc. There is no export wizard.

I have a database of 72 people with their addresses, I manage a family newsletter, and I need to get it converted to an Excel/Calc or MS Access format, or at least to HTML.

How do I do this?

OS: Windows Vista
Version of OOo: 2.3.1
Last edited by Hagar Delest on Tue Jun 10, 2008 3:01 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
Zylstra555
 
Posts: 2
Joined: Sun Jan 27, 2008 10:43 pm

Re: Convert Base to MS Access

Postby Villeroy » Sun Jan 27, 2008 11:27 pm

Open a new spreadsheet.
Call the datasource window (F4)
Browse your database and drag a table onto a cell.
If you don't see your database among the datasources: Right-click in the datasouce window and call the dialog to register databases (make a Base file's tables and queries accessible in other components).
When you have imported your data in a spreadsheet, save in any format you like. Access can import text tables (*.csv) and *.xls.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17320
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Convert Base to MS Access

Postby Zylstra555 » Sun Jan 27, 2008 11:31 pm

Villeroy wrote:Open a new spreadsheet.
Call the datasource window (F4)
Browse your database and drag a table onto a cell.
If you don't see your database among the datasources: Right-click in the datasouce window and call the dialog to register databases (make a Base file's tables and queries accessible in other components).
When you have imported your data in a spreadsheet, save in any format you like. Access can import text tables (*.csv) and *.xls.


You, are now, my hero!

Thank you so much! Thats exactly what I needed!
Zylstra555
 
Posts: 2
Joined: Sun Jan 27, 2008 10:43 pm

Re: [Solved] Convert Base to MS Access

Postby Liliane » Thu Jan 29, 2009 6:50 am

Hi,

i have the same problem with one difference: I have tried to drag the table into the spreadsheet but only the names of the fields appeared the data i have entered. I am still using OpenOffice 2.4 and i have Windows Vista, if that makes any difference. I would appreciate if someone could help me, since i have entered the data of more than 500 customers.
Liliane
 
Posts: 2
Joined: Thu Jan 29, 2009 6:29 am


Return to Base

Who is online

Users browsing this forum: No registered users and 8 guests