Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BCP and VFP Memo fields
Message
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01230554
Message ID:
01230584
Views:
25
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform