I am working with Ultipro, an Human Resources software that has a reporting/query tool that enables users to create reports that can be downloaded to Microsoft Excel. I have created a prototype Access Database that I upload the Excel data from Ultipro so that other calculations and reporting can be done.
The Excel data from Ultipro is uploaded to the Access Database once a month so only at this point is it identical to Ultipro. What I am curious to know is there a way to connect Microsoft Access directly to Ultipro so the data is not static (at month end) and is real-time. It doesn't even have to be Microsoft Access. I could imagine that the Power Pivot table functionality of Excel would work well too.
Does anyone have experience is doing this with Ultipro, or other similar software? Thanks. - Tom