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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
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
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 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
    IB-29041624-0 Profile Picture
    IB-29041624-0 1,191 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,613 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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,344 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,742 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,231

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans