To connect to MS Visual Foxpro Tables (*.DBF files) using the ODBC driver (Open DataBase Connectivity) please follow the procedure below:

Start Excel

Open the Connection dialog: SQL*XL | Connect...

Start the Data Link Properties wizard

Choose the Provider Microsoft OLE DB Provider for ODBC Drivers.

Select your data source name (DSN) from the list.

If there is no DSN for your database in the list use the Refresh button. If it is still not in the list you may need to create a new DSN using the ODBC Data Source Administrator

After you choose a data source name, type in the username and password.

Always use the Test Connection button before you continue

After connecting to the database once you can reconnect by selecting the connection from the Connection History list and typing the Password.

See also:

• Connecting to Oracle through OO4O
• Connecting to Oracle through OLE DB
• Connecting to a database
• Connection dialog
• ODBC Data Source Administrator
• Data Link Properties wizard