Home Button  Buy Button 

Topic:   Excel - Microsoft Query

By: Steve TPosted on: Aug 9 2022 at 03:20:57 AM
Is it possible to pull data from the MRP using Excels "Get Data: From Other Sources: Microsoft Query"?

By: GuestPosted on: Aug 9 2022 at 06:46:03 AM
Yes. We do this all the time.

Although the data isn't easy to read. What I mean is that if you look in the purchase orders table you won't see any actual part numbers so it won't be immediately obvious what you're looking at.

For example the data file is usually named MRP5DATA and that data file contains a number of tables. One of the tables is named "tblstockitems" This contains all the part numbers and descriptions. In that table is a column "ItemID". Everything else in the database, purchase orders, BOMs etc. All just contain that ItemID instead of an actual part number.

But if you 'GET DATA and have a few tables in excel shets AND if you're able to create a macro or VBA script to join or merge sheets based on the relevant IDs you can get pretty much anything you want.

By: Steve TPosted on: Aug 10 2022 at 01:51:53 AM
ok so this is going to be fun then. The excel sheet I'm making is already pretty macro-heavy and slow, and so far I can't seem to find the MRP folder so I am guessing it's on one of our closed access servers :(

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Excel - Microsoft Query

Enter the numbers.

Your name here is optional