• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. Linking, Importing, and Expor... > Exporting Data to Web Servers

Exporting Data to Web Servers

Access 2003 has the capability to export data from tables and queries in the following Web-enabled formats:

  • HTML Documents (*.html; *.htm) for static display of data in pages delivered from any Web server. Exporting as HTML is the simplest process.

  • Microsoft Active Server Pages (*.asp) for dynamic display of data in browser-independent Web pages delivered from Internet Information Server (IIS) 3+. You must specify an OLE DB or ODBC data source and other parameters to export data to an .asp file.

  • Microsoft IIS 1-2 (*.htx: *.idc) for dynamic display of data in a format determined by a Filename.htx template file. The Filename.idc file defines an Internet data connection and an SQL query to generate the data for the page. You must specify an ODBC data source and other parameters to export data to a .htx/.idc file pair. This option is available only for Access data projects (ADP) with SQL Server databases; Access version 2000 and earlier supported this option for Jet databases. This format is obsolete and isn’t secure.

  • SharePoint Team Services() to export a table to a list on a Windows SharePoint Services (WSS) server. Chapter 26, “Integrating with InfoPath and SharePoint Services,” explains how to take advantage of Access 2003’s new WSS list export and linking features.

  • XML Documents (*.xml) for use with applications that can parse and transform XML to HTML or text. As mentioned near the beginning of this chapter, Chapter 23 covers the use of Access 2003’s new XML import/export features for intranet- and Internet-based database applications.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint