Hi,
I would love to help you execute your project.
I have 27-plus years of experience in Software development/Web development/DBA/QA Analyst/Project Management at Strand Management Solutions, Inc. - https://strandmanagement.com.
Our team has the necessary resources to start your project as soon as possible and complete it within reasonable time.
With more than 2 decades of VBA experience, we created many MS Access projects including MS Access 2016 as front end with Access as backend or with SQL Server as backend for many of the clients. In many of the cases, we needed to export or import data from Excel, CSV files. As we link database tables in Access, we can link Excel sheets to Access. Recently, for a valuable client, we handled Excel data from Access including locking, unlocking programmatically, writing data, allowing user to use specific cells of the Excel file. Access VBA code and Excel macros were used in that functionality. So, when needed, we can code Access and Excel to handle data as needed.
We have enormously used Access objects including Tables, Queries, Linked Tables, Pass through Queries, Forms, Reports, Macros, etc.
I understand the general overview of this task. Let me know if we can set up a time to chat about your project in more detail. I would love to connect with you, discuss the project details, and get the job done.
Thanks,
Asharani Thadimari