Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fox Pro to Sequel (No Wizzard) Help with MEMO
Message
From
29/07/1997 14:04:45
 
 
To
29/07/1997 13:29:11
Michael Pittser
Commercial Financial Services
Tulsa, Oklahoma, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00042152
Message ID:
00042157
Views:
37
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform