update DB via MS Query from WS
I think you want to go to the database and import the worksheet. You can't
export the file from excel unless you write VBA go to do the write.
"Gaylen" wrote:
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.
|