跳到主内容

搜索

搜索

Permission To Open The Excel File

评论

4 条评论

  • 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.
    0

请先登录再写评论。