Strange Behavior Using Excel Spreadsheet

Legacy Poster

• June 14, 2012 22:37

I am using a spreadsheet as a database in Bartender 9. I have a column of over 300 numbers that Bartender is converting to individual barcoded labels. The column is mainly numbers, but the last 6 entries are alphanumeric. When I browse the spreadsheet withing Bartender's database setup wizard, those alphanumeric entries in the table are blank. I tried changing the data format in excel options from "general" to all kinds of different options, but Bartender still thinks those entries are blank. But, if I copy those values to a brand new sheet in excel, Bartender can read the entries just fine. Is this a known glitch? Can I fix it?

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • June 15, 2012 00:44
  Yes - I have seen that many times, that's strange behavior of MS OLEDB/ODBC automatic data type detection.
  
  [url="http://seagullscientific.invisionzone.com/index.php?/topic/608-serial-number-with-letters-and-numbers-from-excel/page__view__findpost__p__1752"]See this post's troubleshooting guide.[/url]
  
  Also, use CSV (Mixed quote and comma) text database or other RDBMS (Access, SQL Server etc) can be alternative.
  Excel is a very good spreadsheet, however - not designed as a database.

  0

Please sign in to leave a comment.