Issue 29259

Summary: Export sheet/selected table to SQL
Product: Calc Reporter: stp
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 1.1.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

Description stp 2004-05-17 13:15:52 UTC
To allow quick insertion of data into a database it would be great if I could
export a sheet/selected table to SQL. The SQL for creating the table could be
optional.

Example:
Tablename | columnheader1 | columnheader2
-----------------------------------------
row1      | row1field1    | row1field2
row2      | row2field1    | row2field2

Should export a .sql-file with the following text content:
INSERT INTO 'Tablename' SET columnheader1 = 'row1field1', columnheader2 =
'row1field2';
INSERT INTO 'Tablename' SET columnheader1 = 'row2field1', columnheader2 =
'row2field2';
Comment 1 oc 2004-05-24 14:21:45 UTC
This is a request for enhancement. => Bettina please check .
Comment 2 bettina.haberer 2010-05-21 14:40:53 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".