ODBC Linking Tutorial

How to Link OBDC to CAPITAL Databases

This tutorial was done using Windows 2000 Professional. Windows 98 and 95 are similar but not exactly the same.

1. Open the Control Panel in Windows

2. Goto Administration Tools under Windows 2000 and select the Data Sources icon

3. Under Win9X go straight to the Data Sources icon in the Control Panel

4. Select the File DSN Tab

5. Click Add

generate/odbc_lin1.gif

6. Select a Visual Foxpro Driver (preferably the one below) but there are others..

generate/odbc_lin2.gif

7. Give the DSN a friendly name.

generate/odbc_lin3.gif

8. Click Finish.

generate/odbc_lin4.gif

9. Select Free Table, then type the path to your files.

generate/odbc_lin5.gif

This is should be the result...

generate/odbc_lin6.gif

You can know go into MS Excel and create an external data link via MS Query to any of the CAPITAL databases.

$C:\FORHELP5\htmlgifs\home.gif$