Csv File As A Dta Source

Legacy Poster

• March 15, 2012 22:19

I currently use Excel as my Data Source.
I have 3 columns of Data - Columns B, C & D
I concatenate the 3 columns into Column A and read the Data from Column A

If I create a csv File with just the 1 concatenated column, can I use it as a Data Source instead of the xls?

thanx

Pervez

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • March 16, 2012 00:46
  Hi Pervez,
  In short answer, Yes.
  To change database connection method from Excel to CSV, you need to remove current database connection from File > Database Setup, then add database as Text file : Mixed quote and Comma.
  
  Besides you can concatenate columns in BarTender's text / barcode.
  In object's datasource tab, click[Advanced] button at the right bottom to show substring list.
  You can add a database field by [New] button in mini toolbar in left bottom.
  (in 10.0 or later, you can add datasource from mini toolbar in left bottom.)

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • June 12, 2012 11:34
  I am a new user of Bartender and have created a simple test file in XL to use. It is a single column saved as .xlsx file.
  
  I am getting an error stating that it is an incorrect data type. Should I be only using CSV or tab delimited files created in excel?
  
  Thanks
  Bud

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • June 13, 2012 01:42
  Hi Bud,
  
  You might have mixed data type column problem - which described in a PDF attachment in post below.
  http://seagullscientific.invisionzone.com/index.php?/topic/608-serial-number-with-letters-and-numbers-from-excel/page__view__findpost__p__1752
  
  Um - yes, using CSV is good idea. actually.

  0

Please sign in to leave a comment.