>Ken;
>
>I've done it a lot.
>
>I assume the data you have is in a VFP Table. Here are the steps I take.
>
>[1] Create the SQL Table (usually with an identity column for primary key)
>
>[2] Create a remote view of the SQL Table, make it updateable
>
>[3] Verify that the field names in the VFP table MATCH the field names in
> the sql table.
>
>[4] Open the remote view
>
>[5] Append from the VFP table
>
>[6] TABLEUPDATE()
>
>That works fine. In fact, I have a nightly process that does just that
>with text file data from the nt logs of about 12 pcs. The logs are spooled to text files, the text files imported to vfp tables and then uploaded. They do this so they can charge their office users with for the number of pages of printing they do!
>
>
>>I know how to connect. Doing the inserts by SPT is easy enough: I call a stored procedure on the SQL server and pass parameters to it or I build a string that inserts one row at a time into the target table. What I haven't figured out how to do is to populate a remote view and then bulk update/insert the contents of that view into its source SQL table. BTW thanks for replying. : )
>>
>>
>>>>I want to push some records into SQL Server from a temporary VFP table. What works? I'm certain it can be done, but I haven't gotten it right yet. Ideas please. : )
>>>
>>>If you are in VFP, you can use SPT, a view, etc. Do you need help on getting connected to SQL Server?
Thanks. : )
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement