Exporting data from sqlserver to Excel
-
hi, i need a help in an automation of data fetch from db to excel. I am having 2 tables in sql server db. at present i will type hundreds of number in excel sheet then i will import that to sql server as a table then executing that table and the primary table using some sql statement i used to fetch the required information. now the problem is when we are doing it for multiple records its too difficult to repeat the process repeatedly.so i want to automate this process. for example: primary table: slno eno,ename, eaddress, ecity exporting data through excel is eno comparing this eno in excel with the primary table i can fetch the remining details to the specified set of eno. how to automate if anyone have idea please share it. so that i can begin my process as soon as possible.
Tech_spidy
-
hi, i need a help in an automation of data fetch from db to excel. I am having 2 tables in sql server db. at present i will type hundreds of number in excel sheet then i will import that to sql server as a table then executing that table and the primary table using some sql statement i used to fetch the required information. now the problem is when we are doing it for multiple records its too difficult to repeat the process repeatedly.so i want to automate this process. for example: primary table: slno eno,ename, eaddress, ecity exporting data through excel is eno comparing this eno in excel with the primary table i can fetch the remining details to the specified set of eno. how to automate if anyone have idea please share it. so that i can begin my process as soon as possible.
Tech_spidy
I would used DTS. It comes with SQL Server. If you have sql server 2000 go to where you start enterprise manager. There is an icon that says import export. If you are using sql 2005 you need to go to the database you want to export the table. Right click the database go to tasks then export. Pick your sql server name and database to export from. Pick Excel from the drop down and set the output file name. Then pick the table / table names or do a query. I think that could work pretty nice for you process. I hope that helps. Ben
-
I would used DTS. It comes with SQL Server. If you have sql server 2000 go to where you start enterprise manager. There is an icon that says import export. If you are using sql 2005 you need to go to the database you want to export the table. Right click the database go to tasks then export. Pick your sql server name and database to export from. Pick Excel from the drop down and set the output file name. Then pick the table / table names or do a query. I think that could work pretty nice for you process. I hope that helps. Ben
This is what i am already doing. I need a solution like by clicking a single button it has to export the data by executing the query in db.
Tech_spidy