Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

How to add tables and views from a SQL data source

SQL Server 2000

Tables or views that exist in the SQL data source can be added to SQL-enabled models.

To add tables from a SQL data source

  1. In the Project Explorer window, double-click the module file (.eqm) in the project to the tables are to be added.

    The Model Editor specific to that project and the Model menu appear.

  2. On the Model menu, click Import Tables.

  3. In the Available list of the New Databases Tables and Views dialog box, double-click the table, tables, or views to make them accessible to the model, and then click OK.

    To add all of the tables, click the >> button.

    To remove a table, select it from the Selected list, and then click the < button.

See Also

Model Editor

New <Database Object> Dialog Box

© 2015 Microsoft