If you have the full verion you have to save the excel file as CSV format and
then import the CSV into studio express.

see webpage
http://social.msdn.microsoft.com/for...-134fe66c378c/

"Gaylen" wrote:

That is exactly what i want to do. but finding the import on sql mangement
studio express is the problem.

"joel" wrote:

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.