Here is my dilema. I have made an ODBC connection between FoxPro and SQL server. I am trying to write a stored proc to connect to foxpro and retrieve data from a table and insert it into a SQL table I have built.
Can anyone tell me what the syntax is to connect and retrieve the info?