View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gaylen Gaylen is offline
external usenet poster
 
Posts: 7
Default update DB via MS Query from WS

I want to Use Microsoft Query to update SQL database from excel spreadsheet

The Excel worksheet is first retrieve from the SQL data base using ms query.

in excel i make changes to the data in the excel worksheet. After all
changes is done i want it to be send back to sql databse or update sql
database.