>Exploring options for migrating VFP data to SQL 2005.
>
>I don't know much about BCP but do I understand correctly that you can't move VFP memo fields to SQL Text or VARCHAR(x) this way?
I have never had luck using BPC for memo fields, but I gave up rather quickly when I realized the extended computer time to import the memos using a view or SQLEXEC() was a lot cheaper than my time to figure out the BPC, assuming it was even possible.
Since BPC is importing a text file, it didn't seem possible to find a delimiter that would work universally. On the other hand, decent documentation on BPC is very hard to find, so maybe there is some other way I never found.