Apart from using DTS and Export wizard, we can also use this query to export data from SQL Server2000 to Excel
Create an Excel file named testing having the headers same as that of table columns and use this query
insert into OPENROWSET('Mic rosoft.Jet.OLED B.4.0',
'Excel 8.0;Database=D: \testing.xls;',
'SELECT * FROM [SheetName$]') select * from SQLServerTable
To export data from Excel to...
Leave a comment: