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 |
|
na2173
Starting Member
38 Posts |
 Posted - 2003-11-13 : 15:19:58
|
| HiHas any one tried exporting data from excel using linked server, i was able to set up the linked server, but i was not able to select the data. does any body know how to select the data from the excel sheet |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-13 : 15:26:45
|
| Why not use DTS?Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-11-13 : 15:39:56
|
| ?????How about from Excel?File > Save As > myFile.txt?????What does the query look like?Brett8-) |
|
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-11-13 : 16:55:50
|
| select *fromopenquery(myExcelLinkedServerName, 'select * from [Sheet1$]') |
|
|
|
|
|
|
Exporting excel in sql server