2018.1

Microsoft Access
1. Enter the appropriate information to connect to the database:
l
File name: Browse to your Microsoft Access database file (.mdb)
l
Password: Enter a password if one is required.
2.
Click Next and enter the information for the source table.
l
Connection string: Displays the full path to the database.
l
Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
3.
Click Finish to open the database.
SQL Server
1. Enter the appropriate information to connect to the database:
l
Server: Enter the server address for the SQLServer database.
l
Port: Enter the port to communicate with the SQLServer. The default port is 1433.
l
Database name: Enter the exact name of the database from where the data should
be extracted.
l
User name: Enter a username that has access to the SQLServer and specified
database. The user only requires Read access to the database.
l
Password: Enter the password that matches the username above.
2.
Click Next and enter the information for the source table.
l
Connection string: Displays the full path to the database.
l
Table: Use the drop-down to select the appropriate table or stored query to retrieve
the appropriate data set.
l
Encoding: Use the drop-down to select the encoding with which to read the data in
the table.
3.
Click Finish to open the database.
Page 665