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 -
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] > >
