Create an ODBC DSN for an MS Access File

Overview of the Connection Properties

Connecting to the ODBC Provider

Create an ODBC DSN for an Excel File

 

Create an ODBC DSN for an MS Access File

Do the following:

1. On the Windows Start menu, click Settings, click Control Panel, click Administrative Tools, click Data Sources (ODBC). The ODBC Data Source Administrator dialog box is displayed.
2. In the Data Source Administrator dialog box, click the User DNS tab if you want the data source to be visible only to you on this machine, or click the System DSN tab if you want the data source to be visible to others on this machine and on the network. Click Add. The Create New Data Source dialog box is displayed.
   NoteYou may not use the File DSN tab, because Fdo does not support its use.
3. In the Create New Data Source dialog box, click Microsoft Access Driver (*.mdb), click Finish. The ODBC Microsoft Access Setup dialog box is displayed.
4. In the ODBC Microsoft Access Setup dialog box, in the text entry box labeled Data Source Name , type the name for the data source that you want to use as the value of the DSN parameter in the connection string, click Select. The Select Database dialog box is displayed.
5. In the Select Database dialog box, browse to the folder where the MS Access file is, select the file, and click OK.
6. In the ODBC Microsoft Access Setup dialog box, click OK.
7. In the Data Source Administrator dialog box, click OK.