Database With Excel 关注

0
Avatar
Legacy Poster

Hello. I have a little problem. I installed a bartender for one of my customer. I use a excel database for all the info (in this case , nutrition facts and ingredients) . When i use the format here at my place , the ingredients all show up on the template no problem. But when i try it at my customer place , it stop at 256 characters even if there more characters to be printed . I can see all the characters in the cell in excel but bartender is transferring only 256...  I use a office 2007 , and my customer a 2013.  Help!  :)

2 评论

0
Avatar
Legacy Poster
评论操作 固定链接

I use a paragraph in Bartender, and the database field link to this paragraph is a Microsoft Excel Table. 

0
Avatar
Canguita
评论操作 固定链接

Hello,

This is an Excel limitation. Excel is using WCHAR as data type that only allows 255 characters. As a workaround you can force to have the first database record longer than 255 characters, so Excel automatically will change the data type as memo which allows more than 255 characters (536870910 characters):

 

 

 

http://www.excelforum.com/excel-programming-vba-macros/355677-remove-255-character-limit-from-ole-db-net-and-fix-data-corruptio.html

请先登录再写评论。