Dinbandhu wrote:
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
It looked from the Java error message that you quoted as if the string
it was objecting to was "08/18/2001 12:00:00 AM" and that's what I was
referring to, but in any case the process is the same if the data looks
like "11/28/78". During the import, if you've chosen to copy structure
and data, as you go through the dialogs selecting Next, after the one
about "Apply columns" you see one called "Type formatting" that lists
each field on the left-hand side. Click on the name of the field that
contains your date; you'll see on the right-hand side what type Base is
anticipating at this point. If it doesn't show Date[DATE], select that
format from the dropdown menu. Then you should be able to select Create
and get your data in a form you can use. Its default is usually
Text[VARCHAR] where just about anything goes, so I don't know why it was
having trouble at all.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
