Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mgonzales
Starting Member
2 Posts |
 Posted - 2008-02-29 : 05:27:31
|
| Is there a way to convert sql files to Excel files? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-29 : 05:30:22
|
SQL files? What is that? Do you mean tables in a SQL Server database?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
mgonzales
Starting Member
2 Posts |
Posted - 2008-02-29 : 06:09:28
|
| The file named .sql and i think this is a Sql database files.What I trying to do is to convert the .sql database or maybe a database script files to Microsoft Excel files? Would it be this possible?Is there any application available to help me converting?Thanks in advance. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-02-29 : 06:28:12
|
| could you please explain us exactly what is your requirement?VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-02-29 : 08:55:55
|
.sql is the default extension for you the procedures etc. It is basically a text file. Why do you want to convert that to Microsoft Excel ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-29 : 08:59:31
|
| I think OP is mixing data file with sql files. Mgonzales, do you want to dump/export your data in the excel?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2008-03-01 : 16:03:18
|
| if you are using office 2007 (with sql server 2005) there is very simple GUI to export data from sql tables to excel tables (you need to set the connection string and off you go).if you are using sql server 2005 enterprise edt. with full permission on the database, you can use export DTS wizard. also quick and easy. |
|
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-03-03 : 00:21:50
|
| Try this Go to Toolsin that --> query results--> sql server--> results to file-->ok-->open new window-->select database-->select sql procedure-->exec-->save to allfiles with name as query.xls |
|
|
|
|
|
|
converter Sql to Excel