Installation and New Features Guide (Windows)
Table Of Contents
- Chapter 1: Welcome to FileMakerPro
- Chapter 2: Installing FileMaker Pro in Windows
- Chapter 3: Installing FileMakerPro in the Mac O...
- Chapter 4: New features in FileMaker Pro
- Chapter 5: ODBC import with FileMaker Pro
- Appendix A: MacIPX control panel
- Appendix B: Installing Win32s
ODBC import with FileMaker Pro 5-3
FileMaker Pro is certified with the following ODBC data sources
and drivers:
The Microsoft Excel and Microsoft Access ODBC drivers are available
with Microsoft Office. Trial versions of the other drivers are included
with FileMaker Pro. For information on purchasing ODBC drivers, visit
the INTERSOLV Web site (http://www.intersolv.com) or contact
another ODBC driver manufacturer.
If you already have ODBC drivers installed and you have defined data
sources, you’re ready to import ODBC-compliant data into
FileMaker Pro.
SQL support in FileMaker Pro
The FileMaker Pro query builder helps you easily search a DBMS, fetch
specific records, and import the resulting records into a FileMaker Pro
database.
FileMaker Pro provides an easy-to-use interface to create SQL queries
containing the Select keyword and the Where and Order By clauses. You
can also type SQL statements directly in the SQL query box.
Use the Select keyword to specify which tables and columns your SQL
query will contain. For example, the following SQL statement,
containing only the Select keyword, would retrieve all the records
(rows) from the Company_Name and the Amount columns in the
Sales_data table:
SELECT Sales_data.Company_Name, Sales_data.Amount
FROM Sales_data
Platform Certified ODBC data sources
Mac OS Oracle 7 (INTERSOLV)
Text (INTERSOLV)
Windows 98, Windows 95, Windows NT Microsoft Excel (INTERSOLV, Microsoft)
Microsoft Access (Microsoft)
Oracle 7 (INTERSOLV)
SQL Server (INTERSOLV, Microsoft)
Text (INTERSOLV, Microsoft)