OLEDB Import of Chinese Unicode characters

I'm attempting to batch import excel data in VBA using

cnn1.Open "Provider=Microsoft.ACE.OLEDB.12.0;" & _
"Data Source=" & Excelfile & ";" & _
"Extended Properties=""Excel 12.0;HDR=Yes;IMEX=1"";"
rst1.Open "SELECT * FROM [A1:E502];", cnn1, adOpenStatic, adLockReadOnly

The data includes a mix of English and Chinese characters and unfortunately the imported data sets all Chinese characters to '?'

For example, 'Portfolio 保證組合' imports as 'Portfolio ????'

Can anyone suggest a way aroun开发者_开发百科d this?

Create an array of words and put the chars of the string into the array.
Now you can see the character codes that get imported.