Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

Hi Dan,
Dan Lewis schrieb am 16-Sep-20 um 16:29:
I have a dBase database with several tables. How do I open this database in Calc so that each table will have its own sheet?

Here something different than simple copy:

1. You make a .odb file for the dBase database and register it. That is in File > New > Database. Make sure, that you have set the correct character set in Edit > Database Properties > Additional Settings.

2. You open the spreadsheet and show "Data Sources". That is menu Edit or Ctrl+Shift+F4. You should now see an area above the sheet, which has on the left side an overview over your database files.

3. Drag a table (or query or view) from there to cell A1 on an empty sheet. That will import the table. That is not a simple import, but the spreadsheet is linked to the database table. It has generated a "data range". Look in menu Data. You will see the import in "Select Range" -and more important- you can use "Refresh Range" to bring changes from the database table to the spreadsheet. In case the database is not "connected" right-click the database name and choose item "Registered databases" and select it.

And yet another way to copy:
Open the .dbf file in Calc and resave it with a different name.

Kind regards

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.