User`s guide

4 Using Database Explorer
4-8
Configure ODBC Data Sources
When setting up a data source for an ODBC driver, the target database can be on a
PC running the Windows operating system. Or, the target database can be on another
system to which the PC is networked. These instructions use the Microsoft ODBC
Data Source Administrator Version 6.1 for the U.S. English version of Microsoft Access
2010 for Windows systems. If you have a different configuration, consult your database
administrator for help with your data source setup.
1
Close open databases, including tutorial.mdb in the database program.
2
Open Database Explorer by clicking the Apps tab on the MATLAB Toolstrip. Select
Database Explorer from the Database Connectivity and Reporting section in
the apps gallery. Alternatively, at the command line, enter:
dexplore
If no data sources are set up, a message box opens. Click OK to close it. Otherwise,
the Connect to a Data Source dialog box opens. Click Cancel to close this dialog box.
3
Click the Database Explorer tab. Select New > ODBC to open the ODBC Data
Source Administrator dialog box to define the ODBC data source.
Requirement: When using a 32-bit version of Microsoft Office, use a 32-bit version of
MATLAB to complete the remaining steps.
4
Click the User DSN tab and click Add.