Link to home
Start Free TrialLog in
Avatar of BKennedy2008
BKennedy2008

asked on

Excel Update with SQL connection

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.
Works fine
Issue:
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.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Jaes Overley
Jaes Overley
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial