Excel Update with SQL connection
Posted on 2014-07-11
Here is a good one that I would need assistance with:
I have a Roster with Badge Numbers and a Labor Class in a SQL DB.
I have an excel sheet (.Xlsm) that connects to the DB and pulls the labor Roster into a Table.
Sometimes the users have to edit the Excel Roster with a different Class for a specific Job.
If I need to add users to the Roster, I need to UPDATE the Table with the latest Roster Numbers ONLY.
For Example: The Table contains Badges 100 through 150. I added Badge 151.
When I execute a sub inside Excel, I need to add any new badges after 150 Only. If I just pull down the entire roster again, it will overwrite the changed Class values on the table.
I would imagine I need to change the query for an Update, and change the Connection to ReadOnly= False for the Excel sheet, but I am not sure.