Post reply

Importing data from Excel

  • August 14, 2008 at 4:35 am

    #857937

    Hello,

    It sound like it could be a permissions issue to me as well. Can you check which account the SQL Agent runs under? (Via Computer Management --> Services node)

    Can you then check if that account has permissions on the Network Folder where the Excel file is?

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

  • August 14, 2008 at 5:12 am

    #857955

    Hi

    Thanks a million.

    We changed the SQL Server Agent to run under a local user account which also exists on the machine which hosts the Excel file. All appears to be well now.

    Your assistance is greatly appreciated.

  • August 14, 2008 at 5:24 am

    #857961

    Hi,

    Thanks for the update. I'm glad to hear the issue is resolved.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply