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

Posted on 2008-11-09
Last Modified: 2012-05-05
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.
Question by:vietpa
    1 Comment
    LVL 2

    Accepted Solution

    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 -


    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    This video discusses moving either the default database or any database to a new volume.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now