web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Import an Excel File f...
Small and medium business | Business Central, N...
Suggested Answer

Import an Excel File from Local machine automatically in BC Saas

(0) ShareShare
ReportReport
Posted on by riya patel 82

Hello Experts,

We have one requirement to import the excel file into a staging table and from that it will go to sales journal in Business central saas version from predefined location on  local machine i want to do this process without asking the user for location on web client . how can we do that?

Any help will be appreciated.

Thanks

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at

    That is not possible in Saas unless you store your files on OneDrive or on any Azure storage / Sharepoint.

  • riya patel Profile Picture
    riya patel 82 on at

    Thanks for your response.

    How can we do that with azure storage for excel file.

    Thanks.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,105 Moderator on at

    Microsoft have released a module for this:

    docs.microsoft.com/.../module-integrate-azure-blob-service-rest-api

    So you will have to do some development around that. If i find some codesamples i will update here later.

  • riya patel Profile Picture
    riya patel 82 on at

    Thanks for your help

    yes code samples will be of much help.

  • riya patel Profile Picture
    riya patel 82 on at

    and how is this possible with one drive do you have any help for that

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,529 on at

    This is not for Excel but it may give you an idea

    www.dynamicsblog.at/.../

    Also this is an idea to mount Azure as local drive demiliani.com/.../

  • riya patel Profile Picture
    riya patel 82 on at

    Thanks for the reply.

    The link you provided is accepting text as a response but i have no clue how to work with excel in such scenario.

    Moreover the i just need to read the file stored in azure storage so we do not need to mount the local drive.

    Regards

  • riya patel Profile Picture
    riya patel 82 on at

    Hi Inge,

    i have found one link www.linkedin.com/.../business-central-azure-blob-storage-bert-verbeek in this case he is uploading the attachment. i think we can do this with creating an instream from blob i have found a function  getblobasstream and then we can use excelbuffer functions.

    is my solution feasible?

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans