Is it possible to update a database using excel data form?
I can create the database connection and display the table data in the spreadsheet and when I click on form it displays a form and allows me to scroll through the data.
But when I click on new and enter details nothing happens and the new record is not inserted into the database.
I can create the database connection and display the table data in the spreadsheet and when I click on form it displays a form and allows me to scroll through the data.
But when I click on new and enter details nothing happens and the new record is not inserted into the database.