Share via

Is there a way to have Task Scheduler export an excel file from a network drive to a SharePoint folder

Anonymous
2023-07-25T14:41:55+00:00

Hello:

Would there be a way to have Task Scheduler export an excel file from a network drive to a SharePoint folder.

Thank you,

Robert

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-25T15:07:48+00:00

    Dear respected RDMas,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, I'm sorry and I'm afraid to say that Task Scheduler itself doesn't have native support for directly exporting Excel files from a network drive to a SharePoint folder. We feel your pain due to this limitation and we’re really feel sorry for it. However, we appreciate your understanding.  I do understand the inconvenience and apologize for it.

    However, based on my research a lot you maybe achieve using scripts.

    I'm really sorry I deliver you bad news and I apologize for it.

    Appreciate your patience and understanding and thank you for your time and cooperation.

    Sincerely,

    Waqas Muhammad

    0 comments
  2. Anonymous
    2023-07-25T15:46:52+00:00

    Hello Waqas....Thank you for the reply.....I do have a question.....I did find something that looks valid for this in the attached link...Specifically option #3.

    I hate asking you to look at this, but if you get a chance could you give this a quick glance and give me an opinion. The internet is full of BS and I'm hoping this isn't one of those instances.

    https://sharepointmaven.com/3-ways-import-excel-sharepoint/ Thank you,

    Robert

    0 comments
  3. Anonymous
    2023-07-25T16:07:40+00:00

    Hi respected RDMas,

    Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

    And I appreciate your kind words.

    The third option is acreate a list from Excelfeature, you make a table (formatted your Excel data into table format) from the Excel files and create items in SharePoint list from data in Excel file.

    And a create a SharePoint online list from Excel, not all the column type are supported, you may manually set up. For example, a column in the spreadsheet that contains dates will typically be a date column in the SharePoint list.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely,

    Waqas Muhammad

    0 comments