/iknow-pic.cdn.bcebos.com/30adcbef76094b3669df8c4fadcc7cd98c109dc7"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/30adcbef76094b3669df8c4fadcc7cd98c109dc7?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/30adcbef76094b3669df8c4fadcc7cd98c109dc7"/>
2、表格填制完毕,确认无误后按快捷键执行宏:执行宏快捷键:Ctrl+a,出现如图提示按“结束”即可。
/iknow-pic.cdn.bcebos.com/7e3e6709c93d70cf340e3daff6dcd100bba12b9f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/7e3e6709c93d70cf340e3daff6dcd100bba12b9f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cf340e3daff6dcd100bba12b9f"/>
3、点击“VOU”工作表可以看到执行宏后的数据;注意:如有科目需项目核算的,可以在U列“F21项目编码”填入项目编码。如无则不需要填列,继续如下步骤。
/iknow-pic.cdn.bcebos.com/f7246b600c33874472efb9de5f0fd9f9d72aa06e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f7246b600c33874472efb9de5f0fd9f9d72aa06e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/f7246b600c33874472efb9de5f0fd9f9d72aa06e"/>
4、另存“VOU”工作表,修改保存类型为:CSV(逗号分隔):
/iknow-pic.cdn.bcebos.com/8326cffc1e178a82ebe3e802f803738da877e8b1"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8326cffc1e178a82ebe3e802f803738da877e8b1?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/8326cffc1e178a82ebe3e802f803738da877e8b1"/>
5、将凭证导入模板关闭,不保存凭证模板。
/iknow-pic.cdn.bcebos.com/b3fb43166d224f4aa9aee4b107f790529822d159"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/b3fb43166d224f4aa9aee4b107f790529822d159?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/b3fb43166d224f4aa9aee4b107f790529822d159"/>
6、找到另存命名为“1”的CSV文件,将此文件以“写字板”或“记事本”的方式打开。
/iknow-pic.cdn.bcebos.com/d0c8a786c9177f3e6c606aaf7ecf3bc79f3d563f"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d0c8a786c9177f3e6c606aaf7ecf3bc79f3d563f?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/d0c8a786c9177f3e6c606aaf7ecf3bc79f3d563f"/>
7、打开后将“写字板”或“记事本”格式的文档另存。修改保存类型为:文本文档:
/iknow-pic.cdn.bcebos.com/8b82b9014a90f60327d80ae53712b31bb051ed2c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/8b82b9014a90f60327d80ae53712b31bb051ed2c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/8b82b9014a90f60327d80ae53712b31bb051ed2c"/>
8、接着进入用友,登录“总账工具”。
/iknow-pic.cdn.bcebos.com/060828381f30e924d2db0a9342086e061d95f711"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/060828381f30e924d2db0a9342086e061d95f711?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/060828381f30e924d2db0a9342086e061d95f711"/>
9、点开总账工具后,导入刚才保存好的文本文档:
/iknow-pic.cdn.bcebos.com/35a85edf8db1cb13a7faaab1d354564e93584b85"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/35a85edf8db1cb13a7faaab1d354564e93584b85?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/35a85edf8db1cb13a7faaab1d354564e93584b85"/>
10、数据检查通过后,开始引入:
/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a4660f11d9b6563f6246a60af45"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a4660f11d9b6563f6246a60af45?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/0df3d7ca7bcb0a4660f11d9b6563f6246a60af45"/>
11、导入成功的效果展示:
/iknow-pic.cdn.bcebos.com/ac4bd11373f0820265b9069d45fbfbedab641b6c"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/ac4bd11373f0820265b9069d45fbfbedab641b6c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="https://iknow-pic.cdn.bcebos.com/ac4bd11373f0820265b9069d45fbfbedab641b6c"/>
1:数据库的连接字符串如下: Provider=SQLOLEDB.1Integrated Security=SSPIPersist Security Info=FalseInitial Catalog=数据库名Data Source=localhost2:数据库服务器端用户属于administrators组 3:数据库服务器端的安全性中验证方式设置为windows方式建立MYsql数据库必须拥有一个mysql账户,账户是用户登录的钥匙,也可以理解为一个登陆凭证,就好像现在物业公司的门禁系统一样没有任何账户的系统是不存在与实际应用中的
所以mysql数据库源码安装是必须设置一个管理员账户才可以继续的
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)