7.8. 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.
Get Beginning Access™ 2007 VBA now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
