Issue 105691

Summary: Append data from sheet
Product: Base Reporter: villeroy <villeroy>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.1.1 RC2   
Target Milestone: ---   
Hardware: Unknown   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description villeroy 2009-10-07 17:52:05 UTC
Many people collect data in emailed spreadsheets and it is a quite common
problem that OOo does not allow to merge tables or collect records from various
sources.
When I drag a spreadsheet range into the beamer, the only reactive part is the
tables section of some database. I drop my range and then I have to enter the
table name and choose option "Append Data".
I believe that Base could be a little bit more attractive if you could collect
data a little bit easier.
2 things I could think of:
Drag and drop on a table should start the import wizard with the right table
name and append option.
The same should be possible with writable queries. A query starting with the
right order of fields could help to import data in two steps. Drag&drop and
confirm the field order.