On Wed, 2007-08-29 at 20:01 -0500, Barbara Duprey wrote: > > 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.
I see. I'll check that window again for the Type formatting. Although, I think I did look there earlier and it seemed like the default Types were matching up. Tell me, is this copy table wizard usually trouble-free? Or are others also having trouble with it. I just want to get a sense of whether this tool is quite finicky, or is it just an isolated sort of problem I am having and for most folks it goes without a hitch. Also, is the other method--via the cvs file--more dependable? That is, would you recommend that I go that route instead? If so, is there a simple command in MS Access for exporting a database as a cvs file? Until I get all my databases brought over, I hope not to have to engage in a huge struggle every time I have to import another database. If one of the two methods is more dependable or user-friendly, I'll certainly pursue that. Regards, Swarup P.S. Don't know whether you had a chance to take a look at the functionality issue re: when you have simply "connected" with a MDB, which I had asked Frank about in my last note to him. I have pasted it just below. Any comments? > > 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. I see. That is still very good. I was just unable to find the commands of how to write data there. That is, the tool bar commands for save, edit data, cut, paste, and data input, are all grayed out. Then there above those are the File, Edit (all lines grayed out except "copy"), view, tools, window, and help options but none of them seem to have any option to edit the edit the data, add a row, add a column. And I can't even put my cursor in any of the cells of the table. In fact, there is no cursor. In short, in my computer the table and the data in it looks like a picture window. You can see it, but you can't do anything with it. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
