Writing Only Part Of The Data To The Inlay

Legacy Poster

• 10. September 2012 11:14

i am trying to write data to an inlay but only part of the data (only 8 blocks) were written instead of 27.
the data is read from database, an excell file wihch all the data in a single cell.

thanks,
Alon

0

• 

  Fernando Ramos Miracle

  ★ BarTender Hero ★

  • 17. September 2012 09:04
  Hello Alon,
  
  I guess that when speaking of an "inlay" you mean a text object right?
  
  Could you explain in further detail what do you mean by having several "blocks of data" in the same Excel cell?
  
  In any case, note that Excel is not a database, it is a spreadsheet application where its documents (worksheets) can contain tabulated data rather like a standard database table. The main problem with Excel is the way in which it stores data. The underlying data is stored in a single standard way using a standard, "one size fits all" data type. This is necessary to maintain the flexibility of what can be entered into individual cells. Excel can then apply extra formatting to the data when presenting it in the Excel workbook. When an external application connects to the underlying data of a work sheet the ODBC or OLE DB driver requires that a data type be selected for each column of data. The driver makes a best guess based on the data for each column for the first few rows excluding the field header. Any data that does not fit within the data type specified by the driver gets dropped by the driver which is why you sometimes see [u]missing field data[/u].
  
  You can force Excel to store data as a string (text) data type by prefixing cell values with a ' mark. For example:
  
  '12345678
  'ABCDEFGH
  '1234ABCD
  
  Alternatively you could save the Excel file as a CSV file which is in effect a text file using comma and quote delimiters. The formatting done in Excel with the exception of the ' prefix has absolutely no effect on the underlying data, which is why it makes no difference when read with BarTender.
  
  In my opinion the best approach if you are having difficulties with missing data is to use a [u]proper database[/u] such as Microsoft Access or any one of the many database programs available.

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.