Strange Behavior Using Excel Spreadsheet
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 ★
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.
Comments
1 comment