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.
|