I have a SQL Server 2008 database that I need to have a couple of interns do a lot of data entry to. This will be direct writing to a single table.
To this end, I thought the easiest solution would be to connect an Excel spreadsheet as the front end to the SQL Server table. However, it would appear not so easy. After adding several rows, the data doesn't seem to be moving up to the SQL Server table.
Am I missing a switch that I need to set to allow adds/changes made to the spreadsheet to be added to the database?