>Is there a way to import or use an SDF file. SQL compact database file in foxpro.

You can do the same way (just change the connection string) as you do with the regular SQL Server file. As long as you can connect to this file, you should be able to extract information from it.