trouble maintaining french characters when importing a DBF data file

Posted on 2009-02-10
Last Modified: 2013-11-05
My SQL Server 2005 doesn't have a selection for DBF formatted files when importing data. I need to move this file from its current DBF format into SQL. I've tried importing via Access and Excel, delimited files, etc., but the characters always get screwed up. In other words, the characters such as "e" with an access over the letter, etc. The DBF and DBT files are zipped here:

Driving me mad! I would really appreciate any advice.
Question by:bbdesign
    LVL 23

    Expert Comment

    What are the datatypes of the fields in your SQL 2005 db into which you're trying to import this data? Are they unicode fields (NVARCHAR/NTEXT) or not (VARCHAR/TEXT) ?

    Author Comment

    The table doesn't exist. I'm trying to import this into a new table, I've been using SQL defaults.

    Author Comment

    I solved this problem using a program called DBF Viewer 2000 to do a conversion to Excel.

    Accepted Solution

    Solved this using a program called DBF Viewer

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how the fundamental information of how to create a table.

    755 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

    23 Experts available now in Live!

    Get 1:1 Help Now