Issue 48529 - Ability to create a full-function DB from a spreadsheet/workbook
Summary: Ability to create a full-function DB from a spreadsheet/workbook
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m95
Hardware: PC Windows XP
: P2 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2005-05-02 04:58 UTC by jskeater
Modified: 2013-02-07 22:38 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
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