>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