C# Programming
09-18-2009, 11:31 PM
Import data in excel with OPENROWSET
but i want set formats of cell like date(dd-MMM-yy),number
and text but all should be done by sql server
or in predefine excel sheet
but not through excel objects.
but i want set formats of cell like date(dd-MMM-yy),number
and text but all should be done by sql server
or in predefine excel sheet
but not through excel objects.