Microsoft Office Tutorials and References
In Depth Information
Define a Data Source
Chapter 8: Querying Data Sources
You are returned to the
Create New Data Source
dialog box.
If you specified a login
name and password as
part of the data source,
you can click to select
this check box to save the
login data.
^ Click OK.
‚óŹ
^
You are returned to the
Choose Data Source
dialog box.
& Click Cancel to bypass
the steps for importing
the data.
Note: You will learn how to
perform these steps in the rest of
this chapter.
&
You can now use the
data source in Microsoft
Query.
Change It!
The Choose Data Source dialog box
does not enable you to reconfigure a
data source. To reconfigure a data
source, press Windows Logo+R to open
the Run dialog box, type odbcad32 , and
then click OK. In the ODBC Data Source
Administrator dialog box that appears,
click the File DSN tab. Click the data
source you want to work with and then
click the Configure button to open the
Setup dialog box for the database driver.
Remove It!
If you have a data source that you no longer
use, you should delete it to ensure that only
usable data sources appear in the Choose
Data Source dialog box. Click the Data tab,
click the Get External Data drop-down arrow,
click From Other Sources, and then click
From Microsoft Query to display the Choose
Data Source dialog box. Click the data
source and then click the Delete button.
When Microsoft Query asks you to confirm
the deletion, click Yes.
 
Search JabSto ::




Custom Search