I have a small comma delineated database. How do I config and import it into Base?
The direct approach: Create a new odb-File and - when asked - select connect to an existing Database of Type Text. You select the folder wich contains your csv as source of the database (not the csv-file itself). All csv-files in the folder are shown as different tables of the database.
As a bunch of text-Tables is limited in use, it might be better to create an empty database, generate a table with appropiate types for all columns, load your csv in calc and copy the whole table from calc to the database-table.
But as Base connects to several different databases you have to think, why do you wan’t to use a database. Safety of types, multi user possibilities, defined relations… This is important für the selection of the database.
J.
Thank you. I decided that Calc was simpler for my database which is really more like an extended phone book. So I left it there. Simple solution.
“How to” on this subject at…
http://sheepdogguides.com/fdb/fdb1imp1.htm
That’s OLD! And written for OO. But it only goes into basic things, which I believe still work. Please let me know if you hit any major issues.