Error Connecting To Excel Follow

0
Avatar
Legacy Poster

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.

2 comments

0
Avatar
Legacy Poster

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
Avatar
Legacy Poster

[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

Please sign in to leave a comment.