Strange Behavior Using Excel Spreadsheet S’abonner

0
Avatar
Legacy Poster

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?

1 commentaires

0
Avatar
Shotaro Ito
Actions pour les commentaires Permalien

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.

Vous devez vous connecter pour laisser un commentaire.