Setting up Excel 2008 to read the K4 database. 

While there are a number of programs that you can use to download K4 data, Excel provides a view of the K4 database structure. If you are familiar with SQL database then it should be easy to map out the entire K4 database schema and to set up SQL commands to download the data you need. The K4 database naming conventions make it quite clear which fields are used to join tables.

Once you create your SQL command you can do the download in Excel or you might find it easy to use the same command in FileMaker Pro. It is beyond the scope of this article to attempt to teach data queries in Excel, SQL, or relational database theory.

Excel is a good tool because it lists the table, allows you to explore them graphically and then quickly test your queries. My only complaint is that it only shows 61/2 rows of a table.

  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage.jpg
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
Microsoft Excel1.jpg
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage.jpg
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.
droppedImage_1.png
  1. Open Excel. I have used both Excel 2004 and 2008 for the Macintosh with success.
  2. Select New Database Query... from the Data menu 
  3. The iODBC Data Source Chooser will now open. click on the line with the name K4 and then click on OK.
  4. Enter the K4 administrator name and password.


     
  5. The Microsoft Query window should open and you now have access to the K4 database.

    The main window is used to create the query and the floating Tables window holds the database’s table. To create a SQL query drag drag the tables from the Tables window to the main window. Fortunately the naming of the K4 tables and fields makes it easy enough to find the necessary data and create relationships.
  6. Tables are related to each other by draging lines from the one table to the many table. Explaining relational database theory is beyond the scope of this article. Here is the query completed, show first in Query View and then in SQL view.
    SELECT objects.name, status.name, users.name, objectVersions.createdTime, objectVersions.checkoutDuration, objectVersions.index FROM objects, status, users, objectVersions, issues WHERE (issues.name = 'November') AND (objects.objectType = 0) AND (objectVersions.objectID=objects.id) AND (objectVersions.statusID=status.id) AND (objects.issueID=issues.id) AND (objectVersions.createdUserID=users.id) ORDER BY objects.name, objectVersions.checkoutDuration, objectVersions.index
  7. In English, first the fields to be downloaded follow SELECT, WHERE defines the search criteria and ORDER BY sorts the data. In each item the table name is followed by a period and the field name.
  8. Click on the SQL View to see the SQL statement created by Excel. You can then use this SQL statement directly in another database. Another approach to accessing this data is to use FileMaker Pro.