Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP Tables
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
Divers
Thread ID:
00745769
Message ID:
00745883
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform