Update Kanji Char in SQL Database from Access returns question mar

S

sjalter

I'm trying to update a SQL database from ms access. There is a a lot of
Japanese data in kanji. I've imported the data into Access from Excel and it
looks fine.

When I do an update query in Access to the MS SQL db via ODBC, much of the
data becomes question marks.

All driver versions I could think of are listed below.

This is all being done on a Japanese workstation to a Japanese server.

Do I have to make any special configurations? Is there anything I can do?

Thanks.

Stuart

Access version - 2000 9.0.2720
SQL Server 2000.85.1132.00

Running the following dll's:

odbccu32.dll 3.525.1132.0
odbccp32.dll 3.525.1132.0
odbccr32.dll 3.525.1132.0
odbcad32.dll 3.525.1132.0
odbccp32.dll 3.525.1117.0
odbc32.dll 3.525.1132.0
odbcint.dll 3.525.1117.0
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACCESS 2003 CRASH EXAMPLES 9
Retrieving data in pivottable from Access / SQL server 3
Retrieving data in pivottable (Excel) from Access / SQL server 0
Create Stored Procedure in SQL server from Access VBA? 4
I can't update SQL server 2005 and can't access database in BC man 1
How to generate a GUID in SQL Server via Access 2
SQL 2005 Linked table returns #Deleted in all records/columns 0
Converting Varchar Hyperlink address from SQL Server to real hyperlink in MS Access 3

Top