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) > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
