This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

  • Article

Datasheet view

A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.

Aa210835.dsvw(en-us,office.10).gif

To open a table, form, query, view, or stored procedure in Datasheet view, go to the Database window, click the type of database object under Objects, click the database object you want, and then click either Open or Design. (By default, forms open in Form view. To switch to Datasheet view in a form, click the arrow next to View Aa210835.view1(en-us,office.10).gif on the toolbar.)

If the table, query, view, or stored procedure is already open, switch to Datasheet view by clicking View Aa210835.view(en-us,office.10).gif on the toolbar.