Error Connecting To Excel

Legacy Poster

• 14 de octubre de 2011 11:46

Hi,

I am new to Bartender and after looking at some examples I tried connecting my own Excel file as DB to the label I have made but I am not able to connect to it. The error says Database not in expected format.

Can you please tell what format should I keep the excel worksheet and cell. Currently I have kept 6 columns in text format and 2 columns in number format.

Looking forward to some assistance.

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • 14 de octubre de 2011 12:40
  A. Close your excel file before trying to open in BarTender
  
  B. I usually save the files as .xls, even if using Excel 2007 or 2010 where the defaults is .xlsx.
  
  C. If all else fails, copy and paste your data into a fresh excel chart and re-save.
  
  D. Also watch this video if still having issues http://www.seagullscientific.com/aspx/training-video-(reading-data-from-database).aspx

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 15 de octubre de 2011 03:46
  [quote name='nRyder' timestamp='1318596005' post='805']
  A. Close your excel file before trying to open in BarTender
  
  B. I usually save the files as .xls, even if using Excel 2007 or 2010 where the defaults is .xlsx.
  
  C. If all else fails, copy and paste your data into a fresh excel chart and re-save.
  
  D. Also watch this video if still having issues http://www.seagullscientific.com/aspx/training-video-(reading-data-from-database).aspx
  [/quote]
  
  Dear Ryder,
  
  Thank you for your help, it worked. I have to keep the excel file in .xls format
  
  Thanks,
  
  G patel

  0

Iniciar sesión para dejar un comentario.