VBA script
Budget: €30 – €250 EUR
Before answering, please read everything ESPECIALLY the last paragraph.
The project consists of accessing a postgres database from an excel sheet. To be more concrete, it is expected to use a connector that does not require any additional software to be installed, either OBDC or AOBDC.
It is intended that by clicking a button a form is opened, where some parameters are placed, such as the database, the year, the range of months, and one more field of the table (the criteria correspond to fields of the table). From there, the script should access the database and should create a table for each record that meets the criteria chosen on the form.
The database access data, server name, user and password, can be left in the VBA code and no form is needed for that.
When answering, please specify which method you intend to use to access the database and specify whether you can start the project immediately and how many hours you expect it to take to deliver.
The project consists of accessing a postgres database from an excel sheet. To be more concrete, it is expected to use a connector that does not require any additional software to be installed, either OBDC or AOBDC.
It is intended that by clicking a button a form is opened, where some parameters are placed, such as the database, the year, the range of months, and one more field of the table (the criteria correspond to fields of the table). From there, the script should access the database and should create a table for each record that meets the criteria chosen on the form.
The database access data, server name, user and password, can be left in the VBA code and no form is needed for that.
When answering, please specify which method you intend to use to access the database and specify whether you can start the project immediately and how many hours you expect it to take to deliver.