TransferText and German characters ä, ö, ü

[antifashionpimp]

Hi everyone,

Can someone help me please? I am using a form which imports a .csv
file's data into a temporary table called tblQuestImport_csvraw. The
problem is that I am working with a German character set here -
whenever I import some text with those special characters, I get the
wrong data in my temporary table. For example, ä becomes ÷, ö
becomes an o with a little stripe above it, and ü becomes the sign
used for expressing a value cubed (x to the power 3). What the...?

I used the following code for importing the .csv file. My import
specification is set to using German, and Western European(Windows). I
am using a German version of Access 2000.

Set appAccess = New Access.Application
With appAccess
.OpenCurrentDatabase APPPATH &
"\dev_backend\DB_backend.mdb"
DoCmd.TransferText _
TransferType:=acImportDelim, _
SpecificationName:="QuestA Importspezifikation", _
TableName:="tblQuestImport_csvraw", _
FileName:=txtFile.Value
.CloseCurrentDatabase
End With

Kind Regards,
Jean

 

[antifashionpimp]

I wonder if the problem is the font being used to display the table data. Try going into Tools/Options/Datasheet and changing the font.

Tried that thanks, but no effect.

Will probably have to take an update query which cycles through the temporary table and makes the necessary changes, by checking each character for these characters and replacing them with ä, ö and ü.
Or will this take unneccessary time?

Cheers!

 

[antifashionpimp]

OK need some help again.

I took a way around/across this problem, and I want to add an update query after the data has been exported to the temp table.

E.g. if the temp table is as follows:

Field 1 Field2
Name Joe
Age 20
Job kaufmõnnisch 'here is the funny character "õ", should be ä
.... ....

Then i want a query as follows:

UPDATE tblQuestImport_csvraw SET tblQuestImport_csvraw.Field2 = "ä"
WHERE (((tblQuestImport_csvraw.Field2) LIKE 'Chr(245)'));

However, when I run the query, it says it is changing 0 entries, it should be 1!
It seems in the SET clause, it only checks for cell value "ä", and not a character "ä" within a string.

Please help!!

P.S. You might question my table setup for the temp table (records for Name, Age etc.), this is however an easy way of doing what I need to do and I know that its not perfect.