Table of Contents
Connecting to a Microsoft SQL Server Table or View Send comments on this topic.
See Also

Follow the steps below to connect to an SQL Server table or view:

 

Bring up the Data Source Creation Wizard, by navigating to Data->New Connection. Connect to SQL Server 2000, by clicking on MS SQL Server 2000 or connect to SQL Server 2005 or higher, by clicking on MS SQL Server 2005. 

 

 

Set required connectivity information, including the server address, the username and password as well as the name of the database you wish to connect to.  Then click OK.

 

Finally, select the table or view from the list and click OK.  To preview the table, enable the Preview checkbox.

See Also