The project is two tasks:
1. Create an embeeded VBA macro that can send information from excel to SQL.
2. create excel sheet that can collect entire SQL list using VBA.
1. I have an excel sheet that is used by many users daily.
This sheet contains some values that I want compiled in a SQL table.
The values should be picked from the excel sheet and entered as a new row in the bottom of the SQL table. SQL table shall expand with new entries and not be limited to less than 20000 rows.
Values are 20 cells distributed on three sheets in the same workbook. If more simple - the data may be compiled in a hidden sheet before sending to SQL.
VBA macro must be activated when pressing a button. When pressed button should lock and not be able to resend data from this workbook.
2. SQL server data retrieve is done with a new excel macro done in separate workbook.
I have an SQL server account that the SQL part is to be set up in.