how to convert memo field from foxpro file (dbf) to nvarchar in SQL2005

I am converting data (tables) from foxpro file(bdf)  to SQL2005.I want to convert memo fields to nvarchar   in SQL2005 by C# but I dont  know how to convert memo to string in C# to write down database SQL2005.  Give me a solution.
vietpaAsked:
Who is Participating?
 
bchesleyConnect With a Mentor Commented:
If you are accessing the foxpro data through odbc you will not be able to convert more than 254 characters from a memo field.  I recommend that you look at using ADO and the getChuck funtion to access the data.

Here is a link to an MS KB entry that provides an example of writing data to memo fields through ADO that illustrates an approach you may find helpful - http://support.microsoft.com/kb/q208208/

Bob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.