Apache OpenOffice (AOO) Bugzilla – Issue 48529
Ability to create a full-function DB from a spreadsheet/workbook
Last modified: 2013-02-07 22:38:09 UTC
The database access component allows you to link to a spreadsheet/workbook as a database but such a database does not have the full relational DB capability. There should be a way to say you want to create a new full-function database from a spreadsheet/workbook. Ideally this capability should involve the following functions: 1) The ability to use workbooks as a model for the definition of a database. For each spreadsheet within a workbook, the wizard should offer the user the option to create a table, selecting the columns that should be carried into the table and the format for the column. 2) The ability to import information from existing spreadsheets/workbooks into existing databases. The user should have the option of identify a spreadsheet to be used and the association between spreadsheet columns and DB table columns. 3) The ability to cut/copy-and-paste information from a spreadsheet into a table in an existing database, either as data in a previously defined table or as a new table which could then be edited.
send to right adress