On Wed, 2007-08-29 at 02:34 -0400, Andrew Jensen wrote: > since I invited you folks to check out the new wiki page the - FYI - > the site has been unreachable for a while tonight, this will have to > wait till tomorrow -
I have read with great interest the discussion of this matter here, and am looking very much forward to seeing the wiki page. I am trying to accomplish an import of my MDB files into OO Base, and am hoping that by reading through the new wiki page when it comes up, I'll be able to get the import done. In the mean time, I have two questions and if anyone has any insight to these, I would be grateful: 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? It may be that there is enough functionality but just "connecting", that I can get my work done without having to bother. If for example I have a mailing list--an address list--then can I add and remove rows by this "connecting" function? And then, would I be able to create a query in Base to search the list for particular data? I know that I can't use MSA's query in Base, but could I create a query using Base that will work? Or is it that the only thing I can do is to "see" the data and I won't be able to even do simple data additions and removals? 2. I had tried the import following the pathway which Barbary initially described to Robert (below), ie using the tool of first "connecting" to the MDB file using one Base file, and then from there pasting into another Base file and letting the copy table wizard do its job. But I found to my dismay that each time I tried it, I got the same error just in the end of the whole process when the copy table wizard has finished its prompts and is ready to produce the copy, it gives an error message: "Warning! An error occurred. Do you want to continue copying?" If I choose "yes", the table will appear with all the proper columns but with no data. 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. In the copy table wizard, I had selected the option to copy "definitions and data", and then clicked "yes" when it asked me if I wanted it to create a primary key. But no data is getting imported. Just the structure is getting imported. When the data import failed, I tried again and this time in the first window, selected both "definitions and data" and "primary key". But it didn't make any difference-- it still didn't bring in the data. Is there some way to get the data portion of the import to work? Many thanks. Regards, Swarup > On 8/28/07, Barbara Duprey <[EMAIL PROTECTED]> wrote: > > > > > > > > Andrew Jensen wrote: > > > Hi Robert, Barbara > > > > > > Barbara's description of the steps to transfer tables via drag and drop > > is > > > correct. One thing with this is data type mapping, and don't be > > surprised if > > > the first time you try going that route the transfer fails. > > > > > > However, given that you have the data already in CSV style text files > > you > > > have a second option. That is to link the specific text files as TEXT > > tables > > > into a Base file. Then use standard SQL data manipulation statements to > > move > > > the records with the Base file from the linked TEXT file storage to > > internal > > > HSQL tables. > > > > > > There is an excellent "How To" document that covers the steps to perform > > the > > > link available on the French OOo site - in French of course, hopefully > > not a > > > problem for you. Sorry, I can't give you the actual URL to the document > > of > > > the top of my head. > > > > > > Regarding the data type mapping issues, there are a few tips I could > > offer > > > that may help, and as it turns out there is a fair amount of activity > > with > > > people asking MSA -> Base migration questions on at the OOoForum of > > late. > > > Because of some changes in my schedule I am removing my self from active > > > participation at that site, but have offered to help with this > > particular > > > question by creating a "Steps to migrate data from MSA to Base" page on > > the > > > OOo wiki. > > > > > > The first cut of the page will show up later tonight ( early morning > > your > > > time ) and if you get a chance to look at it, I would be *very > > interested* > > > in getting your feed back on content ( Is it clear to you?, Did it > > help?, > > > What could be better? ) > > > > > > The page will be linked to from > > > http://wiki.services.openoffice.org/wiki/MSA-Base_Faq > > > > > > Byer for now > > > > > > Drew > > > > > > ps. I hope you do get a chance to review that tips page.. and you see > > > something, try it, and it is not quite right or might be described > > better- > > > you can update the page directly...t is a wik after all. ;>} > > > > > > On 8/28/07, Barbara Duprey <[EMAIL PROTECTED]> wrote: > > > > > >> > > >> Robert Bladt wrote: > > >> > > >>> Dear Sirs! > > >>> > > >>> I am a very satisfied OO-user. Only I have one problem with the > > >>> database. How can I convert my MS Access-files (tables) to OO Database > > >>> files? I can make semicolon separated files from my Access-files, but > > >>> I still haven't found a way to import this file in my OO Database. > > >>> This is probably basic skills, but it causes me trouble and I would > > >>> very much appreciate any help. > > >>> > > >>> I'm new at this forum so please forgive me if I repeat a question that > > >>> has been answered previously. > > >>> > > >>> Sincerely > > >>> Robert, Denmark > > >>> > > >>> > > >> First, you need to create a Base database that links to your MS Access > > >> .mdb. You will then be able to see a list of all the Access tables by > > >> clicking the Tables icon on the left side of the main Base window, and > > >> you can work with the tables from there. Let's call this database A. > > >> This may be enough for you to do what you want. > > >> > > >> If you'd like to go further, and actually create a Base database that > > >> contains your data without being connected to the .mdb file, you can > > >> create a second Base database.(B). Now you can drag-and-drop a table > > >> from the tables list in A to the equivalent location in B, or > > >> right-click a table in A and select Copy, then click in the tables area > > >> of B and Paste. Either will bring up a dialog that lets you deal with > > >> the data importation into B. > > >> > > >> This is just a sketch of how it works, if you need more details I'll be > > >> glad to help later, or somebody else will. But for me, at least, the > > key > > >> was to realize that everything works from cut and paste rather than > > >> through a specific Import option somewhere. > > >> > > >> (cc to Robert) > > >> > > >> > > >> > > Drew, I'll definitely look at your page when I get a chance (crunch time > > again right now), I'll bet it's great! Thanks for all your effort. > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
