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.--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
