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.

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.

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.

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.

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.