Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing CSV file with accented characters

Status
Not open for further replies.

rogerte

Programmer
Nov 9, 2001
164
GB
I am using Paradox 7, using Paradox tables. The PC is set up with English (United Kingdom) as the default keyboard setting. Every week we have to import several thousand lines of data from CSV files, and this Paradox handles with no problem.

Except that if the text contains French/German accented characters, then some, but not all, of them display as the hash symbol. Editing the table and then pasting in the data from the CSV file results in the characters displaying correctly.

We have tried using different locale settings, but they make no difference.

Can anyone suggest how to get over this problem?

Many thanks

Roger
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top