Permission To Open The Excel File 关注

0
Avatar
Legacy Poster

Hi there.I'm quite new to Bartender.

I am using Bartender to get the information from the Microsoft Excel database and helping me printing the labels.When i add it(i mean the Excel file) in database connection setup,the connection testing is ok but it prompts a message that saying Bartender does not have permission to open the file: C:\.....xls .Whenever i tried to print by select record in it,it prompts me that message too.

Any ideas?

Thank you.

4 评论

0
Avatar
Shotaro Ito
评论操作 固定链接

[quote name='tbzserge' timestamp='1329642943' post='1767']
Hi there.I'm quite new to Bartender.

I am using Bartender to get the information from the Microsoft Excel database and helping me printing the labels.When i add it(i mean the Excel file) in database connection setup,the connection testing is ok but it prompts a message that saying Bartender does not have permission to open the file: C:\.....xls .Whenever i tried to print by select record in it,it prompts me that message too.

Any ideas?

Thank you.
[/quote]
Hi,
If you open the Excel file by MS Excel(or any other application), close the Excel(or the other application) then try again.
If that doesn't work, try creating a simple test format with simple excel sheet, following this [url="http://www.seagullscientific.com/aspx/training-video-(reading-data-from-database).aspx"]video tutorial[/url].
0
Avatar
Legacy Poster
评论操作 固定链接

Thanks for the response.
I have already make sure that i didn't using MS Excel or any application to open the file while i open it with bartender.
But,it still didn't work.
Creating a new simple test for excel is working though but i need to use that previously Excel file as the database.
Could it possibly be caused by the macro in the Excel file that preventing me to read from it? Or i need an administrator privileges on a pc only can read from it? Currently,i am using the user account.I hope i can get the reason of it.

Thanks.
0
Avatar
Legacy Poster
评论操作 固定链接

Can you copy and paste your data from the Excel file you need to a fresh one? Also, save it as .xls rather than .xlsx if you can.
0
Avatar
Legacy Poster
评论操作 固定链接

[quote name='nRyder' timestamp='1329752744' post='1778']
Can you copy and paste your data from the Excel file you need to a fresh one? Also, save it as .xls rather than .xlsx if you can.
[/quote]


Thanks for the suggestion.But,i don't think i can just copy & paste it into a fresh one.I have tried it and the bartender didn't able to read the table.

请先登录再写评论。