Sunday, 17 February 2013

#30. Insert hasil query ke excel

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;Database=C:\testing.xls;',
    'SELECT * FROM [Sheet1$]') select Name, IsActive from MSubCategory

0 comments:

Post a Comment