On Sat, 2007-09-01 at 01:15 +0200, Andreas Saeger wrote:
> Swarup,
> I'm not a developer, so I can hardly tell if things have to be like
> that. I believe that Base has started too late. Until now it is the
> least mature component in this office suite, although a rock stable,
> reliable database could be the most attractive component to serve all
> other components.
> I have experienced that dragging datasource-objects into a spreadsheet
> always imports correct data, whereas the import into a database fails
> frequently (with dates in particular). A spreadsheet is a good
> scratchpad for all kinds of tabular data. You can easily move around
> things, convert from number to text and vice versa. This is why I
> suggest this detour via spreadsheet. Currently I have no office with mdb
> import, but I have tested some queries and spreadsheet import with an
> older version. If you see your data in the datasource window, they
> should import well into a spreadsheet.
> Conversion of dates can be tricky since dates can be represented as
> numbers (counting time-units since a certain point zero), "31.12.1999",
> "12/31/1999", "1999-12-31", just to mention a few western conventions. I
> don't know which flavour of dates comes into play when you try the
> direct way from mdb in Base to the native Base format, but it seems as
> if the import wizzard can not handle the dates. But it imports
> text-values, representing ISO-dates and times ("1999-12-31 23:59:59").
> I should mention that Calc knows two basic types of data: Text (analog
> to varchar in databases) and numners of type double (16 decimal digits).
> All dates, times, booleans are formatted doubles. You may lose some
> precision when you import numbers with more significant digits.Thanks very much for the explanation. It helps a lot in understanding what the difficulties are. It's gotten late for me to embark on this project tonight, but I expect to be able to do it tomorrow evening. Regards, Swarup --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
