Issue 84075 - Import from .xls using Database Wizard
Summary: Import from .xls using Database Wizard
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.3.0 RC1
Hardware: All Windows XP
: P2 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-11-29 10:39 UTC by jon80
Modified: 2013-02-07 22:43 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jon80 2007-11-29 10:39:56 UTC 
Import from MS Excel (.xls) worksheet using Database Wizard

It would be helpful to have the functionality to import from an Excel sheet to a
database within OpenOffice Base.

This would provide the user the opportunity to create custom forms and carry out
some querying on the data within the excel sheet more efficiently (e.g. using
SQL and designated queries).

The excel sheet can include OLE embedded objects (e.g. MS Word  2003 documents,
or .jpg's) as contents of the cell, which would require to be imported along
with the other fields.

Currently OpenOffice uses OpenOffice calc to read MS Excel sheets when using the
Database Wizard.
Comment 1 aziem 2007-11-30 14:42:29 UTC 
Duplicate to issue 51904 ?
Comment 2 christoph.lukasiak 2008-05-06 13:54:54 UTC 
acknowledge
Comment 3 christoph.lukasiak 2008-05-06 13:55:43 UTC 
send further to the requirements team