General information
Title:
Creating SQL Server stored procedure to retrieve dbf data
Environment versions
Network:
Windows 2008 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only