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

x
?
Solved

trouble maintaining french characters when importing a DBF data file

Posted on 2009-02-10
4
Medium Priority
?
398 Views
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:

http://www.bbdesign.com/CATALOG.zip

Driving me mad! I would really appreciate any advice.
0
Comment
Question by:bbdesign
  • 3
4 Comments
 
LVL 23

Expert Comment

by:adathelad
ID: 23600209
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) ?
0
 

Author Comment

by:bbdesign
ID: 23601054
The table doesn't exist. I'm trying to import this into a new table, I've been using SQL defaults.
0
 

Author Comment

by:bbdesign
ID: 23614327
I solved this problem using a program called DBF Viewer 2000 to do a conversion to Excel.
0
 

Accepted Solution

by:
bbdesign earned 0 total points
ID: 23830678
Solved this using a program called DBF Viewer
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Suggested Courses

873 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