Am Samstag, den 28.07.2007, 12:45 -0500 schrieb Barbara Duprey: > This issue is a real killer for me. Is there any way for me to make the > .dbf into a proper database table, with an auto primary key, instead of > a linked .dbf? Or do you have any other suggestions? Thanks.
Yes, there is. But it is not visible from OO.o base itself (funny!?): If you're using Windows as OS you can simply do the following: 1. Navigate the win explorer to the .dbf file in question 2. Drop the .dbf file onto OO.o's Window --> You'll get a Calc(!) document window showing your data (maybe there is a dialog asking for the character set encoding inbetween). 3. Klick the upper left recangle between the column and row header desigantions (the only grey rectangle having no content) for selecting the complete table contents in the calc doc 4. Hit the F4 key --> the "database browser" opens 5. Navigate in the db browser to your registered datasource (I forgot to mention: the datasource of the target .odb has to be registered in OO.o ;) 6. Klick on the black marked table area and hold the mouse key down 7. drag the contents of the calc doc (grabbed with the mouse key) to the "tables" node of the database browser --> the import dialog pops up 8. Select "stucture and data"-type and continue and select "generate primary key" in the next step 9. go on tweaking until the properties of the table are as you like it for importing (e.g. auto-increment for the key field) 10. finish it! Finally you'll have the .dfb table in your .odb file nicely indexed with a unique primary key. For any other OS instead of using drag & drop the "file -> open" menu will do the same thing. Maybe Gnome or KDE or whatever can do d'n'd also. (to the dev crew and other interested audience, too:) a. It's amazing how complicated this simple task reads if written down step by step ... b. How would Joe or Barbara User do this without the intermediate calc document? He and she should be able to do so, there seems to be something missing (at least in my personal capability of using OO.o-Base ;). HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
