Other Ways to Export Data

Yet another way to export data can be implemented using the OutputTo method. The OutputTo method can export data to various formats: ASP, DAP, HTML, IIS, RTF, SNP, TXT, and XLS. The syntax for OutputTo is shown here:

  DoCmd.OutputTo(ObjectType, ObjectName, OutputFormat, OutputFile, AutoStart, TemplateFile, Encoding) 

Please consult Chapter 9 for more information on the OutputTo method, as the entire chapter is dedicated to creating reports and Web-enabled output, including those created with the OutputTo method.

In addition to all the ways you can integrate with external data sources discussed so far, there are two more technologies that have not been touched on. Those two technologies are web services and the SharePoint product family. These two topics will be covered in Chapter 8.