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.

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.

update DB via MS Query from WS
 

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.

update DB via MS Query from WS
 

It is not part of the Free software you have to buy the licensed version. Do
you want to write a macro to upload the data?

see webpage

http://www.experts-exchange.com/Micr..._24005029.html




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

update DB via MS Query from WS
 

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.