Format Excel Sheet and Upload

[Narayanaswamy]

Hai all,

I want to export the data from Excel sheet to SQL database. In the Excel
sheet one column contains the date value and non date like 0 and blank.
I want to transfer this to my table by changing the format to
dd/mm/yyyy.



If I open and format the column to date, and if I export then in the
table i am getting different formats ( based on the client machines Date
format , The column in the table is Varchar becaust the Excel sheet
column will contain date and other non date like 0 , blank etc )



Now how can I export the Excel column that contains date , 0 and blanks
to the table in the database with date format dd/mm/yyyy and null for
non date values?



Thanks

Narayanaswamy