>What I want to do is from Excel click a button and send maybe five pieces of data gathered from specific cells into an existing foxpro table. Can this be done with ODBC connection and sql?

Yes. Create a small VBA program that you assign to the command button.
You could use ODBC (creating a DSN in that machine) or better yet, using ADO and OleDB.

Something like this idea:

' gather info from Excel 

oConn = CREATEOBJECT("adodb.connection")
cConnString = "provider=vfpoledb;data source=mydatabase.dbc" ' or mytable.dbf
oConn.Open(cConnString)
oConn.Execute("insert into mytable (field1, field2) values (cell1, cell2)")
oConn.Close()
oConn = nothing

Of course you would have to adapt to your tables/fields and specific cells. Either all cells at once or onme record per cell, whatever applies to your sample, plus appropiate error trapping in VBA.

Alternatively you could set an OleDB Provider reference in Excel instead of doing it in code.
From the help file:
To connect to a Visual FoxPro database or table in Excel

Open an Excel worksheet. 
From the Data menu, point to Import External Data, and click Import Data. 
In the Select Data Source dialog box, click New Source Data Connection. 
In the Data Connection Wizard, select Other/Advanced. 
In the Provider tab, select Microsoft OLE DB Provider for Visual FoxPro. 

HTH