When you export a datasheet (datasheet: Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.) to ASP (Active Server Page (ASP): A file that contains embedded server-side scripting that is executed on a server and sent to and displayed in a client Web browser as a standard HTML file.) or IDC/HTX (IDC/HTX files: Microsoft Internet Information Server uses an IDC file and an HTX file to retrieve data from an ODBC data source and format it as an HTML document.) output format, the data that you see when you display the file in a Web browser is the actual data in the recordset behind the datasheet. By default, Microsoft Access saves Text and Memo fields with left alignment and saves all other supported data types with right alignment.

When you export a datasheet, Access does not output OLE objects (OLE object: An object supporting the OLE protocol for object linking and embedding. An OLE object from an OLE server (for example, a Windows Paint picture or a Microsoft Excel spreadsheet) can be linked or embedded in a field, form, or report.) or the related values from a Lookup field, and ignores the OrderBy, Filter, Format, and InputMask property settings.

If you want the server-generated HTML files to look like the datasheet in an Access database, you can create and export a query that has the same recordset as the datasheet. When you create the query, do the following:

• Use the Sort cell in the query design grid to sort the data.
• Use the Criteria cell in the query design grid to filter the data.
• Use the Format function to format the fields, such as Currency, Date/Time, and Yes/No.
• Create an Autolookup query to display the values from a Lookup list.

The file may no longer be available. Check with the Web site administrator for the status of the file.

You may not have the correct permissions to access the file. Check with the Web site administrator to determine the permissions needed to access the file.

You must have access to the Internet— for example, you could have a modem and an Internet service provider, or you could have access through your corporation's network— to open files at an FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) site or on the World Wide Web (World Wide Web (WWW): The multimedia branch of the Internet that presents not only text, but also graphics, sound, and video. On the Web, users can easily jump from item to item, page to page, or site to site by using hyperlinks.).

If you have Internet access and you still can't open the file, the site may be too busy. Try to open the file later.

In the Open dialog box (File menu), when you select an Hypertext Markup Language (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) (HTML) file (also called a Web page) and click Open or double-click the file, the file opens in the program that created the file. For example, if you attempt to open an HTML format file that was created in Microsoft Word, the file opens in Word— not in Microsoft Access as a data access page.

1. To open an HTML file that was created in another Office program as a data access page in Access, do one of the following:

In Windows 2000:

• Right-click the file in the Open dialog box, point to Open with, and then click Microsoft Access on the shortcut menu.

  Note  If the file type that you are trying to open hasn't previously been associated with another program, instead of pointing to the Open with dialog, click the Open with dialog, and select Microsoft Access from the list of programs.

The following table summarizes supported products, platforms, and Web page output format files.

Note  To use any Web page from a client computer, you need a Web browser, such as Microsoft Internet Explorer, and a connection to the Internet or intranet server where the Web pages are located. For information about how to set up Internet access, see Windows Help.

Microsoft Access does not support importing or linking data from a remote FTP or HTTP server. Save the file or HTML page to your hard drive or intranet site, and then import or link the file from there.