Issue 29259 - Export sheet/selected table to SQL
Summary: Export sheet/selected table to SQL
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-05-17 13:15 UTC by stp
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

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