troubleshooting Question

Remove Chinese Characters from Excel Spreadheets used as input

Avatar of DMV
DMV asked on
Microsoft Access
14 Comments1 Solution5200 ViewsLast Modified:
Hello All.

I have an A2K application that reads surveys that from Excel worksheets, and tabulates the reponses for further analysis.  This app has been up and running for the past 2 years. The problem arose when the questions were translated into Chinese and place below the English text.  The following method is used to copy the survey into an Access table:

    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, _
            strTableName, strSpreadSheetPath, False, "A1:V133"
    LoadSpreadSheet = True

The Chinese characters are translated into a string of "?"  of various lengths.  One problem is that a question mark signifies the start of the tabulation process.  I've tried ignoring a series of question marks, but some stray characters still remain.  Can I change the default character for unknown symbols?  Actually, I am open to any idea that will allow me to process the surveys as before, outside going through each survey by hand and removing the Chinese translation.)

Many thanks,
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros