Issue 48529

Summary: Ability to create a full-function DB from a spreadsheet/workbook
Product: Base Reporter: jskeater <jskeater>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P2 CC: issues
Version: 680m95   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description jskeater 2005-05-02 04:58:11 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.
Comment 1 christoph.lukasiak 2005-05-02 13:24:36 UTC
send to right adress