>I've some IDs/Numbers in my local table and I want to get the details of all the IDs/Numbers from the SQL database.

You could use OpenRowSet. ie:

SELECT rmtR.* FROM Northwind.dbo.Customers as rmtR ;
   inner join ;
   OPENROWSET('VFPOLEDB', 'c:\myPath\myDatabase.dbc';'';'','select * from myCountries') as locR ;
   on rmtR.country = locR.cntryName

Cetin