2

Is it any method or way to export or transfer the data from sql server 2000 to excel sheet ?

Red Swan
  • 15,157
  • 43
  • 156
  • 238
  • From which end? You say 'export', but 'import' works quite well: http://stackoverflow.com/questions/5010617/query-sql-from-excel-2007-and-return-several-values/5011166#5011166 – Fionnuala Feb 21 '11 at 12:33
  • @Remou, I want to export Or transfer data by inbuilt any tool in sql server 2000. Or import data in excel sheet from sql server 2000 by any tool exist in MS Excel. I must avoid programming for that for now. – Red Swan Feb 21 '11 at 13:03
  • In that case http://office.microsoft.com/en-us/excel-help/use-microsoft-query-to-retrieve-external-data-HA010099664.aspx – Fionnuala Feb 21 '11 at 13:15
  • i think it is about office 2010. is there remedy for office 2003 or 2007 – Red Swan Feb 21 '11 at 13:45
  • The comment at the top refers to a link to 2010, the article itself is about earlier versions, as far as I know. I can certainly get external data with my 2000 version of Excel. – Fionnuala Feb 21 '11 at 16:39
  • You can use OPENROWSET http://www.mssqltips.com/tip.asp?tip=1202 – Sachin Shanbhag Feb 21 '11 at 12:16

1 Answers1

3

to create an EXCEL file in advance and want to export data to it, use

EXEC sp_makewebtask 
@outputfile = 'd:\testing.xls', 
@query = 'Select * from Database_name..SQLServerTable', 
@colheaders =1, 
@FixedFont=0,@lastupdated=0,@resultstitle='Testing details'

(Now you can find the file with data in tabular format)

Alberto Zaccagni
  • 30,779
  • 11
  • 72
  • 106
Raghavendra
  • 31
  • 2