>Is there any way, from within Sql Server. SSMS to do a select from a Dbf table
>Thanks in advance

Yes, but it is not a walk in a park. You'll have to use openrowset. It might not work for VFP databases on 64 bit SQL servers, but will work for Fox2.x dbfs

https://www.sqlservercentral.com/forums/topic/sql-2012-64-bit-quering-dbf-dbase-files
https://www.tek-tips.com/viewthread.cfm?qid=674988
https://www.bigresource.com/MS_SQL-SQL-2012-Import-Visual-FoxPro-Tables-into-Database-50fEMSOK.html#TkP51TNx