Microsoft Office® Access 2007 Inside Out

Creating a Data Source to Link to an ODBC Database

Before you can connect to a database that requires ODBC, you must first create a data source—either a data source name (DSN) file or a data source entry in your Windows registry. A data source is simply a named set of ODBC driver parameters that provide the information the driver needs to dynamically link to the data. To create a new data source name file or registry entry, on the External Data tab, in the Import group, begin importing or linking a file by clicking More and then clicking ODBC Database. Access 2007 opens the Get External Data - ODBC Database dialog box. Select either the Import The Source Data Into A New Table In The Current Database option or the Link To The Data Source By Creating ...