When using Microsoft Excel as a database source for my BarTender label format, why do I often get missing data in some fields?
This is a limitation of Excel, which is not a true database application. The data is dropped by the ODBC or OLEDB connection when the actual data in the field does not agree with the data type given to that field by the connection. The solution is either to export your data to a Microsoft Access database (.mdb file) using a delimited text file, or to “force” the data type used by the field by prefixing your data in Excel with a ‘ character. This forces the Excel ODBC/OLEDB driver to treat the data as string data type. Q: For database-connected objects, I often find the database and field name is too long and this makes my label design awkward. Can I change the appearance of database connected objects, to more easily use them to design my labels? A: Yes you can! Open the properties of the database-connected label objects and select the Data Source tab. Here you will find the database name and field as you see it in the Sample Data text box. You may actually change this text to be anythi
This is a limitation of Excel, which is not a true database application. The data is dropped by the ODBC or OLEDB connection when the actual data in the field does not agree with the data type given to that field by the connection. The solution is either to export your data to a Microsoft Access database (.mdb file) using a delimited text file, or to “force” the data type used by the field by prefixing your data in Excel with a ‘ character. This forces the Excel ODBC/OLEDB driver to treat the data as string data type. Q: For database-connected objects, I often find the database and field name is too long and this makes my label design awkward. Can I change the appearance of database connected objects, to more easily use them to design my labels? A:The Data Navigator feature in BarTender versions 9.4 and above allows you to view database records while in the label design view. This feature can be enabled and disabled using the Data Navigator toolbar in the lower left-hand corner of the
