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.)