To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48529 Issue #:|48529 Summary:|Ability to create a full-function DB from a |spreadsheet/workbook Component:|Database access Version:|680m95 Platform:|PC URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P2 Subcomponent:|none Assigned to:|msc Reported by:|jskeater
------- Additional comments from [EMAIL PROTECTED] Sun May 1 20:58:11 -0700 2005 ------- 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
