Leo Rivers wrote:
This seems hopeful, I can save as *.dbf - BUT - after selecting
"connect to a file" and pointing to the dedicated directory... all my
files are greyed out.
NOTE: I have already given them all read/write/execute permissions.*
Thanks for any help you can give.
* the choices are always grey in wiza too.rd, for csv
There is no csv involved. To be honest, you do not even need to set up a
datasource. It's just the way I use dBase with OpenOffice.org, because a
spreadsheet, overwriting an existing dBase-table may spoil the integity
of data-types and indices. Sorry for mentioning the confusing
database-import.
Try opening your dbf-files directly with Calc: File>Open>Filter:dBase(*.dbf)
Just in case you want to set up a datasource anyway:
dBase is a directory based database. You have some directory with
dbf-files, containing tables with data and some other files,
representing meta-info and indices.
<snip help="dBase; database settings">
Ensure that dBase tables use the .dbf extension in lower case.
</snip>
Having saved your tables as dbf in some directory, you call
File>New>Database
The wizzard offers 3 options:
1. New database (an odb-file self-containing a hsqldb)
2. Open an existing database file (same as file open?)
3. Connect to an existing database with a listbox of types
Use the third option with type "dBase"
Next step lets you pick the directory.
Last step asks for registration as datasource. Yes, check this in order
to get your database shown in the datasource-pane.
You get an OOo-database-file (*.odb) containing the meta-information
(type:dBase and directory) and you may add simple queries, indices,
forms and reports to this odb-file. The tables are not contained in the
odb-file and OOo can not handle relations between dBase-tables.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
