RETURN TO THE ENTRANCE HOME PAGE


WORKING WITH SPREADSHEETS
 
You can use Entrance to pull data from a MySQL database and put it in a spreadsheet, and you can easily move spreadsheet data into MySQL tables.  In this section we describe how to do this using clipboard operations.  (You can also use the import and export dialogs to do this, which is described in another section)
 
HOW TO COPY A TABLE TO A SPREADSHEET

With a table tab selected in Entrance, select "Copy table..." from the Edit menu:

 
 
then switch to your spreadsheet application and paste:



After pasting in Apple Numbers
 
 
HOW TO COPY A FILTERED TABLE TO A SPREADSHEET

With a match pattern or WHERE clause in the table match box you will see a different menu pick:

 
 
In this case, only the rows matching the match box will be copied.  If you have set the table order from a column popup menu, that order will be used for the copy, as well.
 
 
HOW TO COPY QUERY RESULTS TO A SPREADSHEET
 
With a query tab selected you can copy the results it generated to the clipboard for a spreadsheet.   When pasted into the spreadsheet you will have the spreadsheet representation of what is on the Results tab.  Notice the accelerator key for copying results:

 
Ok, now to go the other direction...
 
HOW TO PUT SPREADSHEET DATA IN A TABLE
 
Select the spreadsheet data you want in the new table, then copy it to the clipboard.  In the Entrance Edit menu, select "Paste as table..." which brings up this dialog:

 
 
Click OK to import the spreadsheet  tab delimited data, and a new table containing your spreadsheet data will be created. Now you can change its column names and types using the column popup menus if you choose.
 
You can also append spreadsheet data to an existing table, by selecting "Append rows to existing table".  The three dot button next to the table name box gives you a quick way to find the table.
 


Please note:  This web page and other Entrance documentation web pages are copyrighted material and have not been released under the terms of the GPL.
 
Copyright (c) 2007 dbEntrance Software, All Rights Reserved                       
 
Java and the Java Coffee Cup Logo are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.  Solaris is a trademark of Sun Microsystems, Inc.  MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries.  Windows is a trademark of Microsoft Corporation.  Macintosh and Apple Numbers are  trademarks of Apple Computer, Inc.