Hi Community,

Does anyone know how to write a SQL Server 2008 stored procedure to retrieve data from FoxPro. I have payroll data in visual FoxPro that a third party vendor needs access. The vendor uses SQL Server. I created a staging database on SQL Server. I need to run a stored procedure in SQL Server to get the data after processing has occurred in my FoxPro payroll program. I know how to send data from FoxPro to SQL, but my scenario I will have to provide a store procedure that has to be initiated from SQL Server to get my dbf data. I was unable to find anything on the internet where someone has attempted to retrieve dbf data from SQL Server. Any help, much appreciated. FoxPro still rules.


thanks
Nick