使用docmd.transferspreadsheet导出到excel时,备注字段会被截断 [英] memo field get truncated while exporting into excel with docmd.transferspreadsheet
问题描述
大家好,
我正在使用Access 2007,当我正在尝试使用DoCmd.transferspreadsheet导出查询时。我的备忘录字段被截断为255个字符。
我在网上搜索了答案,我确实看到了很多,但没有任何帮助我。
有没有简单解决方案摆脱这种痛苦...
只是为了解你的知识:
1.我看得很满我的查询中的文字(备忘录)。
2.当我尝试通过GUI导出查询时,它就像一个魅力。
3.我的出口并不简单,它按值导出工作表。(所以我不能真正使用GUI导出)。
4.我已经尝试过使用DoCmd.OutputTo(并且工作正常)但它没有'没有找到床单分离(3)。
感谢任何帮助
Uriya。
hi all,
I''m using Access 2007 and when I''m trying to export a query by using DoCmd.transferspreadsheet. I get my memo field truncated into 255 character.
I searched the web for answers and I did see many, but nothing helped me.
Is there any simple solution to get rid off this pain in the...
just pack of facts for your knowledge:
1. I can see full text(memo) in my query.
2. when I try to export query by GUI it works like a charm.
3. my export isn''t simple, it exports a sheet by value.(so I can''t really use GUI-export).
4.I''ve tried use DoCmd.OutputTo (and it worked fine) but it didn''t worked out with the sheets separation (3).
thanks for any kind of help
Uriya.
推荐答案
这是一个已知的限制。你想要什么?我会想到这会在你阅读之后理解这一点。
我对你的设计知之甚少,但我所能建议的就是你停止使用该字段作为备注。
It''s a known limitation. What do you want? I would have thought this this would be understood after reading about it as you have.
I know little of your design but all I could suggest would be that you stopped using the field as a Memo.
这是在查询到Excel中导出备忘录字段时的一个众所周知的问题。您可以尝试以下几种方法来规避此行为:
This is a well known problem with Exporting MEMO Fields in a Query to Excel. There are a couple of things you can try to circumvent this behavior:
- 导出为Excel 2000格式,即:
- Export to Excel 2000 Format, namely:
感谢回复ADezii,NeoPa。
NeoPa-我必须使用备忘录,因为它需要包含超过255个字符。
ADezii-你为我提供的第一个解决方案(我非常新手)。但我用
thanks for reply ADezii, NeoPa.
NeoPa- I have to use memo cuz it need to contain more then 255 chars.
ADezii- the first solution you gave much more possible for me (im quite a novice). but I do an export with
这篇关于使用docmd.transferspreadsheet导出到excel时,备注字段会被截断的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!