Date conversion between Excel and SQL using openrowset
I have an excel worksheet with only the time populated in a column (e.g. 7:30:00 AM). This defaults to 0/1/1900 7:30 if I format the cell to dd/mm/yyyy h:mm.
I have an excel worksheet with only the time populated in a column (e.g. 7:30:00 AM). This defaults to 0/1/1900 7:30 if I format the cell to dd/mm/yyyy h:mm.