Issue 84075

Summary: Import from .xls using Database Wizard
Product: Base Reporter: jon80 <jon80>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P2 CC: ahz001, issues
Version: OOo 2.3.0 RC1Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: Windows XP   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---

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
Comment 3 christoph.lukasiak 2008-05-06 13:55:43 UTC
send further to the requirements team