O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required