Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>what is fastest way to take records from a VFP table to an SQL table (all field names and definitions are the same in both files)?
>
>I have used append from, but that is slow
>
>Is Insert into the right way?
>
>I do not think I can use SQLEXEC
I doubt that this is the best or fastest way of doing it, but I have a utility which builds the command for an SQLEXEC statement. It does this for one record at a time, but it should be a simple task to modify it to scan an entire table or put some kind of scoping clause into it.
You're probably better off finding a method using remote views, but let me know if this appeals to you and I'll post the code.
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