Database With Excel

Legacy Poster

• 2015年01月05日 14:16

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!  :)

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2015年01月08日 14:10

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

  0
• 

  Canguita

  ★ BarTender Hero ★

  • 2015年01月27日 12:29

  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

  0

サインインしてコメントを残してください。