Microsoft Office Tutorials and References
In Depth Information
Importing Data from SQL Server
4. Choose the table or view you want to analyze and then click Next.
Figure 18-11: Specify your database and then choose the table or view you want to analyze.
5. In the screen that appears in the wizard, enter descriptive information about the connection
you’ve just created (see Figure 18-12).
Figure 18-12: Enter descriptive information for your connection.
This information is optional. If you bypass this screen without editing anything, your
connection will work fine.
The fields that you use most often are
File Name: In the File Name input box, you can change the filename of the .odc (Office
Data Connection) file generated to store the configuration information for the link you
Save Password in File: Under the File Name input box, you have the option of saving
the password for your external data in the file itself (via the Save Password in File check
box). Placing a check in this check box actually enters your password in the file. This
password is not encrypted, so anyone interested enough could potentially get the password
for your data source simply by viewing your file with a text editor.