web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Database Questions
Microsoft Dynamics RMS (Archived)

Database Questions

(0) ShareShare
ReportReport
Posted on by blargyblargness 80

Hello all,

I'm trying to figure out the best way to add new items/tables into Dynamics RMS. I'm running version 2.0 of Dynamics RMS and have access to SQL 2008, but what I'd really like to do is add tables by using existing excel files. These .xls files already have everything that needs to be uploaded into Dynamics RMS.

So basically, what would the best way to upload .xls files into Dynamics RMS? Is there a tutorial online somewhere?

Thanks in advance!

*This post is locked for comments

I have the same question (0)
  • Gerald Rothaus Profile Picture
    Gerald Rothaus 2,934 on at
    RE: Database Questions

    Use access. I do. Create your tax tables, department and category tables, the assign those numbers to each item in your xl sheet. link your access program to your dataset, import your excel sheet into a table, write a vb loop that writes the items into the database table, and viola!

    You can do it in vb or html, but MS Access is built for this sort of thing.

  • Taier P Profile Picture
    Taier P 908 on at
    RE: Database Questions

    Hi there-

    If you have access to CustomerSource, you can download the import utility. mbs.microsoft.com/.../rms_so_importutility.htm

    Otherwise, you can purchase a plug in, such as www.rrdisti.com/.../rr-import-utility.

  • archelle16 Profile Picture
    archelle16 1,743 on at
    RE: Database Questions

    Can u discuss briefly? What do you mean "adding tables by using existing excel files"? What's inside of .xls files?

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans