You could use the openrowset function. It allows you to open and ole db data source in a stored procedure.
-BOL Clip-
The OPENROWSET function can be referenced in the FROM clause of a query as though it is a table name. The OPENROWSET function can also be referenced as the target table of an INSERT, UPDATE, or DELETE statement, subject to the capabilities of the OLE DB provider.

See the BOL for more info.

>Hi All:
> I want to update vfp tables from SP. The tables I want to update are located in a various directories depending on the bill dates.
>For example vfp: table bill date 01/02/03. The directory would be 0203 that I want to update from SP. How can I accomplish this task relatively easy?
>Thanks for all the help.
>MA