[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1149
  • Last Modified:

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.
0
vietpa
Asked:
vietpa
1 Solution
 
bchesleyCommented:
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

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now