Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fox Pro to Sequel (No Wizzard) Help with MEMO
Message
De
29/07/1997 14:04:45
 
 
À
29/07/1997 13:29:11
Michael Pittser
Commercial Financial Services
Tulsa, Oklahoma, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00042152
Message ID:
00042157
Vues:
35
>For some very large foxpro tables (528 tables totaling 15 Gig), I want to use SQL's BCP to import data from these tables. I need to get the data from the columns and from the memo fields into matching SQL tables. BCP reads ASCII text files. What is the easiest way to get the the data from each record along with the memo field text into a text file with the data in the order of the orginal columns separated by tabs and with quotes around the memo field contents? Or, does anybody know of a equally fast way other than using BCP?

You could write a procedure based on low-level file functions, which will scan a table and write data into text file going through all fields adding delimiters. Actually, it might be pretty simple code.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform