Forum Discussion
TulioOliveira
Dec 18, 2024Copper Contributor
Extract Data with VBA in the Project
Hi guys, I need some help.I need to extract data from the project to connect to Power BI. I'm currently using the feature in the database model by going to Report>Visual Report>Save Data Select: Task...
Ignacio_Martin
Dec 23, 2024Iron Contributor
Hi Tulio.
Considering that Access has a database size limitation of approximately 2 GB, it is very likely that you will not be able to export projects over a certain duration and with multiple tasks.
Depending on the information you want to obtain, you could look for an appropriate solution.
There are Project fields that are time-phased (byday) and many others (most) that are not, such as custom fields, which would be easily exportable.
Ignacio