ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 效率神器,一键搞定繁琐工作
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
让更多数据处理,一键完成 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 1423|回复: 0

[求助] Access数据库表中数据转换

[复制链接]

TA的精华主题

TA的得分主题

发表于 2014-1-19 17:49 | 显示全部楼层 |阅读模式
在表中有如下的数据样式,怎么转换成中文文字呢?

  1. {\rtf1\ansi\ansicpg936\deff0\deflang1033\deflangfe2052{\fonttbl{\f0\fnil\fprq2\fcharset134 \'ba\'da\'cc\'e5;}{\f1\fnil\fprq2\fcharset134 \'cb\'ce\'cc\'e5;}{\f2\froman\fprq2\fcharset0 Times New Roman;}{\f3\fnil\fcharset134 \'cb\'ce\'cc\'e5;}}
  2. {\*\generator Riched20 5.50.99.2010;}\viewkind4\uc1\pard\nowidctlpar\fi480\li210\ri210\qj\kerning2\f0\fs24\'c7\'eb\'d4\'da\ldblquote\'b4\'f0\'cc\'e2\rdblquote\'b2\'cb\'b5\'a5\'d6\'d0\'d1\'a1\'d4\'f1\'cf\'e0\'d3\'a6\'b5\'c4\'c3\'fc\'c1\'ee\'a3\'ac\'b2\'a2\'b0\'b4\'d5\'d5\'cc\'e2\'c4\'bf\'d2\'aa\'c7\'f3\'cd\'ea\'b3\'c9\'cf\'c2\'c3\'e6\'b5\'c4\'b2\'d9\'d7\'f7\'a1\'a3
  3. \par \'d7\'a2\'d2\'e2\'a3\'ba\'d2\'d4\'cf\'c2\'b5\'c4\'ce\'c4\'bc\'fe\'b1\'d8\'d0\'eb\'b1\'a3\'b4\'e6\'d4\'da\'bf\'bc\'c9\'fa\'ce\'c4\'bc\'fe\'bc\'d0\'cf\'c2\'a1\'a3
  4. \par \f1\'b0\'c2\'d0\'c2\'b9\'ab\'cb\'be\'bd\'ab\'d3\'da\'c4\'ea\'b5\'d7\'be\'d9\'b0\'ec\'d2\'bb\'b3\'a1\ldblquote\'c6\'f3\'d2\'b5\'c4\'ea\'b6\'c8\'c1\'aa\'bb\'b6\'cd\'ed\'bb\'e1\rdblquote\'b5\'c4\'bb\'ee\'b6\'af\'a3\'ac\'c4\'e2\'d1\'fb\'c7\'eb\'d2\'bb\'c5\'fa\'bf\'cd\'bb\'a7\'b2\'ce\'bc\'d3\'a1\'a3\'d2\'f2\'b4\'cb\'a3\'ac\'cf\'fa\'ca\'db\'b2\'bf\'d0\'e8\'d6\'c6\'d7\'f7\'d2\'bb\'c5\'fa\'d1\'fb\'c7\'eb\'ba\'af\'a3\'ac\'b2\'a2\'b7\'d6\'b1\'f0\'b5\'dd\'cb\'cd\'b8\'f8\'cf\'e0\'d3\'a6\'b5\'c4\'bf\'cd\'bb\'a7\'b4\'fa\'b1\'ed\'a1\'a3\f2
  5. \par \f1\'c7\'eb\'b0\'b4\'c8\'e7\'cf\'c2\'d2\'aa\'c7\'f3\'a3\'ac\'cd\'ea\'b3\'c9\'d1\'fb\'c7\'eb\'ba\'af\'b5\'c4\'d6\'c6\'d7\'f7\'a3\'ba\f2
  6. \par 1\f1\'a3\'ae\'b5\'f7\'d5\'fb\'ce\'c4\'b5\'b5\'b0\'e6\'c3\'e6\'a3\'ac\'d2\'aa\'c7\'f3\'d2\'b3\'c3\'e6\'b8\'df\'b6\'c8\f2 15\f1\'c0\'e5\'c3\'d7\'a1\'a2\'bf\'ed\'b6\'c8\f2 28\f1\'c0\'e5\'c3\'d7\'a3\'ac\'d2\'b3\'b1\'df\'be\'e0\'a3\'a8\'c9\'cf\'a1\'a2\'cf\'c2\'a3\'a9\'ce\'aa\f2 2.5\f1\'c0\'e5\'c3\'d7\'a3\'ac\'d2\'b3\'b1\'df\'be\'e0\'a3\'a8\'d7\'f3\'a1\'a2\'d3\'d2\'a3\'a9\'ce\'aa\f2 2.8\f1\'c0\'e5\'c3\'d7\'a1\'a3\f2
  7. \par 2\f1\'a3\'ae\'bd\'ab\'bf\'bc\'c9\'fa\'ce\'c4\'bc\'fe\'bc\'d0\'cf\'c2\'b5\'c4\'cd\'bc\'c6\'ac\ldblquote\'d1\'fb\'c7\'eb\'ba\'af\'b1\'b3\'be\'b0\f2 .jpg\f1\rdblquote\'c9\'e8\'d6\'c3\'ce\'aa\'d1\'fb\'c7\'eb\'ba\'af\'b1\'b3\'be\'b0\'a1\'a3\f2
  8. \par 3\f1\'a3\'ae\'b8\'f9\'be\'dd\ldblquote\f2 Word-\f1\'d1\'fb\'c7\'eb\'ba\'af\'b2\'ce\'bf\'bc\'d1\'f9\'ca\'bd\f2 .docx\f1\rdblquote\'ce\'c4\'bc\'fe\'a3\'ac\'b5\'f7\'d5\'fb\'d1\'fb\'c7\'eb\'ba\'af\'d6\'d0\'c4\'da\'c8\'dd\'ce\'c4\'d7\'d6\'b5\'c4\'d7\'d6\'cc\'e5\'a1\'a2\'d7\'d6\'ba\'c5\'ba\'cd\'d1\'d5\'c9\'ab\'a1\'a3\f2
  9. \par 4\f1\'a3\'ae\'b5\'f7\'d5\'fb\'d1\'fb\'c7\'eb\'ba\'af\'d6\'d0\'c4\'da\'c8\'dd\'ce\'c4\'d7\'d6\'b6\'ce\'c2\'e4\'b6\'d4\'c6\'eb\'b7\'bd\'ca\'bd\'a1\'a3\f2
  10. \par 5\f1\'a3\'ae\'b8\'f9\'be\'dd\'d2\'b3\'c3\'e6\'b2\'bc\'be\'d6\'d0\'e8\'d2\'aa\'a3\'ac\'b5\'f7\'d5\'fb\'d1\'fb\'c7\'eb\'ba\'af\'d6\'d0\ldblquote\'c6\'f3\'d2\'b5\'c4\'ea\'b6\'c8\'c1\'aa\'bb\'b6\'cd\'ed\'bb\'e1\rdblquote\'ba\'cd\ldblquote\'d1\'fb\'c7\'eb\'ba\'af\rdblquote\'c1\'bd\'b8\'f6\'b6\'ce\'c2\'e4\'b5\'c4\'bc\'e4\'be\'e0\'a1\'a3\f2
  11. \par 6\f1\'a3\'ae\'d4\'da\ldblquote\'d7\'f0\'be\'b4\'b5\'c4\rdblquote\'ba\'cd\ldblquote\'a3\'a8\'bf\'cd\'bb\'a7\'a3\'a9\rdblquote\'ce\'c4\'d7\'d6\'d6\'ae\'bc\'e4\'a3\'ac\'b2\'e5\'c8\'eb\'c4\'e2\'d1\'fb\'c7\'eb\'b5\'c4\'bf\'cd\'bb\'a7\'b4\'fa\'b1\'ed\'d0\'d5\'c3\'fb\'a3\'ac\'c4\'e2\'d1\'fb\'c7\'eb\'b5\'c4\'bf\'cd\'bb\'a7\'b4\'fa\'b1\'ed\'d0\'d5\'c3\'fb\'d4\'da\'bf\'bc\'c9\'fa\'ce\'c4\'bc\'fe\'bc\'d0\'cf\'c2\'b5\'c4\ldblquote\'d1\'fb\'c7\'eb\'bf\'cd\'bb\'a7\'cd\'a8\'d1\'b6\'c2\'bc\f2 .xlsx\f1\rdblquote\'ce\'c4\'bc\'fe\'d6\'d0\'a1\'a3\'c3\'bf\'d2\'b3\'d1\'fb\'c7\'eb\'ba\'af\'d6\'d0\'d6\'bb\'c4\'dc\'b0\'fc\'ba\'ac\f2 1\f1\'ce\'bb\'bf\'cd\'bb\'a7\'b4\'fa\'b1\'ed\'b5\'c4\'d0\'d5\'c3\'fb\'a3\'ac\'cb\'f9\'d3\'d0\'b5\'c4\'d1\'fb\'c7\'eb\'ba\'af\'d2\'b3\'c3\'e6\'c7\'eb\'c1\'ed\'cd\'e2\'b1\'a3\'b4\'e6\'d4\'da\'d2\'bb\'b8\'f6\'c3\'fb\'ce\'aa\ldblquote\f2 Word-\f1\'d1\'fb\'c7\'eb\'ba\'af\f2 .docx\f1\rdblquote\'ce\'c4\'bc\'fe\'d6\'d0\'a1\'a3\f2
  12. \par 7\f1\'a3\'ae\'d1\'fb\'c7\'eb\'ba\'af\'ce\'c4\'b5\'b5\'d6\'c6\'d7\'f7\'cd\'ea\'b3\'c9\'ba\'f3\'a3\'ac\'c7\'eb\'b1\'a3\'b4\'e6\ldblquote\f2 Word.docx\f1\rdblquote\'ce\'c4\'bc\'fe\'a1\'a3\f2
  13. \par \pard\kerning0\f3\fs18\lang2052
  14. \par }
复制代码

您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-11-17 13:53 , Processed in 0.035661 second(s), 9 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表