Data import by dts using sql-server 2000 to excel 2007

Data import by dts using sql-server 2000 to excel 2007

 

 

if you have Office 2007 installed on the system, you must use "Microsoft Excel Driver (*.xls, *.xlsx, *xlsm, *.xlsb)" for the import.

If you do NOT have Office 2007, then download the Office 12 data provider at: http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891