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]