Bring data into Smartsheet with API or ODBC from Excel



Does anyone know how to configure Excel or Smartsheet so that a sheet can read data from Excel? I have it working so that Smartsheet is a source and use excel to pick up a sheet's data but not the other way.

All the literature and videos say it can be done but I cannot find out how!