VBA link to SQL
Budget: $50 – $0 AUD
Hi, I need assistance with VBA code from my Excel spreadsheet. I am trying to link my spreadsheet to SQL data base via VBA code I want to be able to:
- download a list of databases and tables to my spreadsheet
- download the data from the SQL database that I choose from the list in the database
- make modifications in the spreadsheet to the dataset from the SQL database
- upload the modifications through an automated query programmed in VBA coding
Can you let me know if this is possible and if so how much will it cost to get the code and assistance to check the code is working?
Thanks.
- download a list of databases and tables to my spreadsheet
- download the data from the SQL database that I choose from the list in the database
- make modifications in the spreadsheet to the dataset from the SQL database
- upload the modifications through an automated query programmed in VBA coding
Can you let me know if this is possible and if so how much will it cost to get the code and assistance to check the code is working?
Thanks.