B
bavjean
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
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