Update DB2 database in Excel

  • I have a DB2 database and I need the data exported to excel. Then In excel I need to make updates to the fields and click a button that will update the DB2 database. I am not familiar with vba or marcos. Can anyone help me with this issue?



    Example:

    The headers for the fields will be in the spreadsheet, the user will enter data and click the update button. The button will only update the fields with data.

    For user John Doe the only field that will be updated in the database is First_Name, Last_Name, PO#, Item_Count, Order_Date, Ship_Location.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!