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]
