User: msc Date: 05/12/01 02:03:31 Modified: /dba/www/FAQ/ FAQ.html
Log: add new item about importing a spreadsheet File Changes: Directory: /dba/www/FAQ/ ======================== File [changed]: FAQ.html Url: http://dba.openoffice.org/source/browse/dba/www/FAQ/FAQ.html?r1=1.11&r2=1.12 Delta lines: +152 -116 ----------------------- --- FAQ.html 28 Feb 2005 13:38:14 -0000 1.11 +++ FAQ.html 1 Dec 2005 10:03:27 -0000 1.12 @@ -103,6 +103,14 @@ <span style="font-weight: bold;">slow</span></a><br> </td> </tr> + <tr> + <td style="vertical-align: top;"><br> + </td> + <td style="vertical-align: top;"><a href="#import_spreadsheet">How can I import + a spreadsheet table to a database? + </a><br> + </td> + </tr> </tbody> </table> <!-- ########################## content list end ################################ --> @@ -303,6 +311,7 @@ <div style="text-align: right;"><a href="http://www.openoffice.org";>OpenOffice.org</a> - <a href="http://dba.openoffice.org/index.html";>Database Access</a> - <a href="../FAQ/index.html"> Tips and Tricks</a> - <a href="../FAQ/FAQ.html">FAQ</a><br> + </div>div> <div style="text-align: left;"> <h3><a name="dbasequeries"></a>In dBase, I cannot create queries for more than one table</h3> @@ -310,9 +319,11 @@ OpenOffice.org's own dBase implementation. There is an <a href="http://www.openoffice.org/issues/show_bug.cgi?id=8949";> issue requesting this</a>, so if you're interested in this feature, go and <a href="http://www.openoffice.org/issues/showvotes.cgi?voteon=8949";> vote for this issue</a> :).<br> + </div> <div style="text-align: right;"><a href="http://www.openoffice.org";>OpenOffice.org</a> - <a href="http://dba.openoffice.org/index.html";>Database Access</a> - <a href="index.html"> Tips and Tricks</a> - <a href="FAQ.html">FAQ</a><br> + </div> <div style="text-align: left;"> <h3><a name="spreadsheet"></a>I have a Spreadsheet data source, and it does display old data only!</h3> @@ -324,7 +335,7 @@ <br> This is a known limitation in the current implementation of the spreadsheet driver. You may workaround this by disabling connecting pooling in "<span style="font-family: monospace;">Tools|Options|Data -Sources|Connections</span>" - when you do this (you may want to disable it for the + Sources|Connections</span>" - when you do this (you may want to disable it for the spreadsheet driver only, and not gloablly), then simply closing every view to a spreadsheet connection (for instance the data source browser) and re-opening it will give you the most recent data.<br> @@ -340,12 +351,15 @@ requesting to change the behaviour</a> of the spreadsheet driver so that it confirms with other database drivers - namely, it should refresh it's tables when it detects that the underlying file has been changed.<br> + </div> <div style="text-align: right;"><a href="http://www.openoffice.org";>OpenOffice.org</a> - <a href="http://dba.openoffice.org/index.html";>Database Access</a> - <a href="index.html"> Tips and Tricks</a> - <a href="FAQ.html">FAQ</a><br> + </div> + <div style="text-align: left;"> <h3 style="text-align: left;"><a name="evolution"></a>Evolution Address Data Source</h3> - <div style="text-align: left;">The Address Book integration OOo provides is + The Address Book integration OOo provides is mainly done in Mozilla. Yes, in <a href="http://www.mozilla.org";>Mozilla</a> :). Mozilla provides functionality for address book access, and OOo ships with some (slightly modified) Mozilla components, and bridges from the Mozilla XPCOM-API @@ -360,9 +374,9 @@ - <a href="http://dba.openoffice.org/index.html";>Database Access</a> - <a href="../FAQ/index.html"> Tips and Tricks</a> - <a href="../FAQ/FAQ.html">FAQ</a><br> </div> + <div style="text-align: left;"> <h3 style="text-align: left;"><a name="delrecord"></a>I can't delete a record in a dBase Table</h3> - <div style="text-align: left;"> You have activate the 'show inactive Records' option in the datasource setting for the dBase datasource. </div> @@ -370,9 +384,10 @@ - <a href="http://dba.openoffice.org/index.html";>Database Access</a> - <a href="../FAQ/index.html"> Tips and Tricks</a> - <a href="../FAQ/FAQ.html">FAQ</a><br> </div> + <div style="text-align: left;"> <h3 style="text-align: left;"><a name="recordcount"></a>The number of records in my table is not correct.</h3> - <div style="text-align: left;"> + Not until you go to the last record we know the number of records in a table. Until the record count is not final a (*) is displayed behind the record number. @@ -381,7 +396,6 @@ - <a href="http://dba.openoffice.org/index.html";>Database Access</a> - <a href="../FAQ/index.html"> Tips and Tricks</a> - <a href="../FAQ/FAQ.html">FAQ</a><br> </div> - <!-- ########### add new items befor this line and use the template from the end of this file ############ --> <div style="text-align: left;"> <h3><a name="slow_search"></a>When I search data in my form/table, this is incredibly slow</h3> @@ -398,33 +412,55 @@ your form, to let the server do the work.<br> More information is available in the <a href="http://dba.openoffice.org/servlets/ReadMsg?msgId=735536&listName=users";> archive of our mailing list</a>.<br> + </div> <div style="text-align: right;"><a href="http://www.openoffice.org";>OpenOffice.org</a> - <a href="http://dba.openoffice.org/index.html";>Database Access</a> - <a href="file:///G:/src/www/dba/FAQ/index.html"> Tips and Tricks</a> - <a href="file:///G:/src/www/dba/FAQ/FAQ.html">FAQ</a><br> - <br> - <div style="text-align: left;"><br> - </div> - </div> - </div> - </div> </div> + <div style="text-align: left;"> + <h3><a name="import_spreadsheet"></a>How can I import + a spreadsheet table to a database?<br><span style="font-size:70%">Thanks to Regina Henschel for the answer at the mailing list [email protected]</span></h3> + + There two ways<br> + (1) You can create a database file which gives you access to the calc-table. But you cannot alter the table within base, but must use the calc-table<br> + (2) You can create a new database file and import your calc table.<br> + <br> + I refer to the way (2).<br> + 1. Create a new, empty database or open an existing. Leave it open.<br> + 2. Open your Spreadsheet-table.<br> + 3. Mark your data in the Calc-table and copy them into the Clipboard.<br> + 4. Go to the databasefile and use Edit - Paste.<br> + + <br> + You will get the "Copy Table"-dialog, which leads you through the import.<br> + <br> + Instead of Copy&Paste you can also use drag&drop.<br> + 3. Reduce the windows, so that you can see the Database pane of the databasefile window beside the calc table.<br> + 4. Mark all your data in the Calc-table including the headings.<br> + 5. Drag them to the databasefile window and drop them to the "Tables"-Icon in the Database-pane.<br> + <br> + You will get the "Copy Table"-dialog too.<br> </div> + <div style="text-align: right;"><a href="http://www.openoffice.org";>OpenOffice.org</a> + - <a href="http://dba.openoffice.org/index.html";>Database Access</a> + - <a href="../FAQ/index.html"> Tips and + Tricks</a> - <a href="../FAQ/FAQ.html">FAQ</a><br> </div> + <!-- ########### add new items befor this line and use the template from the end of this file ############ --> </div> - <hr style="width: 100%; height: 5px;"> <!-- a template for a new item in the FAQ - + <hr style="width: 100%; height: 5px;"> -<h3 style="text-align: left;"><a name="##name of the bookmark##"></a>## the question ##</h3> +<!-- a template for a new item in the FAQ <div style="text-align: left;"> -## the answer ## + <h3 style="text-align: left;"><a name="##name of the bookmark##"></a>## the question ##</h3> + + ## the answer ## </div> <div style="text-align: right;"><a href="http://www.openoffice.org";>OpenOffice.org</a> -- <a href="http://dba.openoffice.org/index.html";>Database Access</a> -- <a href="../FAQ/index.html"> Tips and -Tricks</a> - <a href="../FAQ/FAQ.html">FAQ</a><br> + - <a href="http://dba.openoffice.org/index.html";>Database Access</a> + - <a href="../FAQ/index.html"> Tips and + Tricks</a> - <a href="../FAQ/FAQ.html">FAQ</a><br> </div> - --> - </div> </body> </html> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
