title: Use ADOX or ADOX and ADODB to query and edit data
body: <p>I am trying to figure out how to use ADO and ADODB to get data and view it while also being able to determine the PK so that I can alter data.</p>
  
  <p>My plan is to use ADODB to display some data to an end user in Excel, if the user wants to edit the data there will be a macro monitoring cell changes and then sending the change to the database.  I need a way to use ADOX to find the keys and alter the data unless I can use ADOX to query and alter the data all in one.</p>
  
  <p>I have experience working with ADODB to communicate with a MySQL database and I know that ADOX can show you keys for database tables and also allows you to easily change the database structures.  I can't seem to find anything with regards to what I am trying to do.</p>