View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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.