On Wed, 2007-08-29 at 09:55 -0500, Barbara Duprey wrote: > > Frank Schönheit - Sun Microsystems Germany wrote: > > Hello Swarup, > > > > > >> 1. I would like to know that if I just simply "connect" to the MDB file > >> and don't import it, then what sort of functionality is there? > >> > > > > Read/Write data. See MSA's queries as so-called views (i.e. they behave > > like tables, but you cannot edit their constituting statement). Don't > > see forms/reports/macros. > > > > > >> And then, would I be able to create a query in Base to search the list > >> for particular data? > >> > > > > Yes. > > > > > >> And if instead I choose "no", then another error message appears: "Wrong > >> data type: java.lang.NumberFormatException: For input string: > >> "08/18/2001 12:00:00 AM". In that situation too, the table will appear > >> with all the proper columns but with no data. > >> > > > > That's somewhat strange. I would guess it seems to depend on your > > concrete data. Since no data is copied at all, I would assume there is a > > field in your very first row which somehow triggers this problem. If you > > have a chance to strip down your MSAccess DB to just this one table with > > just this one record, while the bug persists, I would be interested to > > have a look at it (provided this is no confidential data, of course). > > > > Ciao > > Frank > > > > > Since it seems to be having trouble with the date/time field, have you > checked that the destination field type is appropriate? It may be having > trouble recognizing the format. I'm not sure there's an exact equivalent > for the Access form -- in Writer, I see one that has hh:mm:ss but no > AM/PM, and one that has hh:mm am but no seconds. The second form is > available in Base, and when I copied a table with your data into a field > of that type, it came in OK but minus the seconds. There's also an > "OTHER" format, but I haven't looked into that -- maybe you can define > the format you want?
I don't know how to check that the destination field type is appropriate. But as I mentioned to Frank just now, the piece of data which it didn't like, was just a date in this format: "11/28/78". There was no time there at all what to speak of minutes, seconds etc. So I don't know what the copy table wizard is out of sorts about. If you tell me in very simple step-by-step language how to check what you think I should check, or how to define the format properly, then I'll certainly do it. Many thanks, Regards, Swarup --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
