Robert Bladt wrote:
Thank you very much for your kind answer. It was at great help. Both
connection and importation works fine following your guidance.
Glad to hear it!
And then one further question: Is it possible to enter new data into
the database-table, once it has been imported into the database? Or
shall I enter new data into e.g. an txt-file and make a new OO Base
with connection to the updated txt-file?
Once it's been imported, you have a fully functional database. You can
enter or edit data (you might want to create a Form to do this), create
queries and reports, or whatever.
You might want to consider subscribing to the mailing list, it doesn't
send much traffic and that way you won't miss any answers.
To subscribe to the list, send a message to:
<[EMAIL PROTECTED]>
The message doesn't need any subject or message text. You'll get a
confirmation request e-mail, and when you respond to that you'll start
seeing anything that happens here. Have fun!
Barbara Duprey 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]
