我想用excel将数据库中相同的内容去掉,于是想到了用excel,结果导出后就出现问题
比如我的access数据库内的某个数据是这样的({}内为一条数据)
{ppvod高清$$第1集$2pegmGWdoJLW2tbr2WBmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm5qUx5VamMqcmdbfmQ%3d%3d$ppvod#第2集$2pegmGWdoJLW2tbr22Bmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm5uUx5VamMqcmdbfmQ%3d%3d$ppvod#第3集$2pegmGWdoJLW2tbr12Bmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm5yUx5VamMqcmdbfmQ%3d%3d$ppvod#第4集$2ZegmGWdoJLW2tbr2GBmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm52Ux5VamMqcmdbfmQ%3d%3d$ppvod#第5集$2ZegmGWdoJLW2tbr2mBmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm56Ux5VamMqcmdbfmQ%3d%3d$ppvod#第6集$4JegmGWdoJLW2tbr02Bmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm5%2bUx5VamMqcmdbfmQ%3d%3d$ppvod#第7集$2pegmGWdoJLW2tbr22Bmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm6CUx5VamMqcmdbfmQ%3d%3d$ppvod#第8集$15egmGWdoJLW2tbrlmVon82hztjc4a5amsmYzJuUyWJamJqbkMukipaWZ5yYzcyUxpheZdHjnw%3d%3d$ppvod#第9集$2pegmGWdoJLW2tbrlmVon82hztjc4a5amsmYzJuUyWJamJqbkMukipaWZ52YzcyUxpheZdHjnw%3d%3d$ppvod#第10集$36CdlmVon82hztjc4WNoaszcmcze0q6xXMfYkMqhipZlXMWpk47RmleZmJWjkMvSipObYJLg250%3d$ppvod#第11集$5JegmGWdoJLW2tbrlmVon82hztjc4a5amsmYzJuUyWJamJqbkMukipaWaJWYzcyUxpheZdHjnw%3d%3d$ppvod$}
然后导出EXCEL文档后就成了
{ppvod高清$$第1集$2pegmGWdoJLW2tbr2WBmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm5qUx5VamMqcmdbfmQ%3d%3d$ppvod#第2集$2pegmGWdoJLW2tbr22Bmapfb1JfS1J%2bxaJem09KdyKGis%2bCYzs6UxmRam5SYzJ%2bXipRqXMjUm5uUx5VamMqcmdbfmQ%3d}
内容变少!(有保留格式和不保留格式(不保留格式,用excel打开时显示该文档出现重大错误,需要修复)两种,都有错误)
请问哪位大侠有解决的办法??