一劳永逸的解决ACCESS日文问题
function filteJapanese(sStr)
dim oRegExp
set oRegExp = new RegExp
oRegExp.global = true
oRegExp.pattern = "[\u3040-\u309F|\u30A0-\u30FF]"
filteJapanese = oRegExp.replace(sStr,"")
set oRegExp = nothing
end function
function filteJapanese(sStr)
dim oRegExp
set oRegExp = new RegExp
oRegExp.global = true
oRegExp.pattern = "[\u3040-\u309F|\u30A0-\u30FF]"
filteJapanese = oRegExp.replace(sStr,"")
set oRegExp = nothing
end function