Home > Articles > Data > FileMaker

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Importing and Exporting Data

Having to manually type every bit of data into a database can be an excruciating experience. Fortunately, FileMaker has excellent capabilities for importing data from a wide variety of sources. Later chapters cover integration with other systems. For now, keep in mind that there are options other than spending all day at the keyboard.

Importing data moves data from one environment to another in a batch mode, and that is what the following sections summarize. FileMaker Pro now also provides a number of ways to share data in real time. You can use ODBC to access external SQL data sources in real time. You can also add SQL tables to your database graph, and you can even add supplemental fields to the external tables—your FileMaker database stores the supplemental fields.

  • ccc.jpg To explore how to bring data, including a directory of images, into your FileMaker Pro solution, see Chapter 22, “Importing Data into FileMaker Pro.”
  • ccc.jpg To learn about ODBC connectivity and exporting, see Chapter 23, “Exporting Data from FileMaker.”

Saving PDF and Excel Documents

Often you will want to prepare a report in FileMaker and create an electronic document you can then share with your colleagues. From the File menu, you can now save directly to PDF or Excel without having to use any third-party software.

Notice that you can automatically attach your documents to an email or even use FileMaker to compose an email message from data within your database. This function depends on your having an email client installed on your computer or having access to an SMTP server.

  • ccc.jpg For more information on saving PDF documents and sending email from FileMaker, see “Delivering Reports,” p. 309.
  • + Share This
  • 🔖 Save To Your Account