dBase is a simplified database file format used to store structured data. You can specify an ODBC connection to these files. Each file is considered a separate table in a database; which is considered the folder in which the file resides.
Define the
...
Datasource
From the Administrative Tools area, open the Data Sources (ODBC). The Administrative Tools can usually be found in the Control Panel.
- Select the System DSN tab
...
- Complete the ODBC dBase Setup by entering the Data Source Name, use something that will uniquely identify the source data, e.g. DBF Schools.
- Enter a brief Description for the Data Source if you wish.
- Uncheck the Use Current Directory and using the Select Directory… button, choose the directory where the dbf file is stored.
- Now click OK and the new entry should appear in the System DSN list.
Working with the Datasource in Data
...
Share
Please refer to the topic Adding a new Data Source for the general details on how to add a new Data Source and use the following options.
...