Home Button  Buy Button 

Topic:   Excel from Data File

By: GuestPosted on: Dec 22 2022 at 02:30:04 AM
Hi,
I have seen a few questions about extracting data from the Minimrp data file into Excel.

I am not technical, but think this may help with some of the current addtional work we do with Minimrp - Excel reports, we also import into MS Access then sort and print reports.

Can anyone help me with some really basic steps to import this Datafile into Excel or MS Access, so that i can see whats happening and what it might do for me?

Many Thanks

By: GuestPosted on: Dec 22 2022 at 07:32:30 AM
I used Data> Get Data> From Database> From Microsoft Access Database and selected my MRP5DATA file (you have to change your filter to view "All Files" to see MRP5DATA). It brings up the Power Query Editor then I clicked on the binary file then went up to the top and said to load as Access Database. From here I was able to get to all the data I needed.

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 from Data File


Enter the numbers.

Your name here is optional