I have a data in the excel file and I need to import the data into sqlserver. I can do this bit by importing data into a temporary table and then from that temp table to import/insert into my required table. its works fine.
The problem I have, in the excel file I have a one column showing date's (format: e.g. Wed 1 Sep) and I am having a difficulty to import that column. The format of the date is bit different than the normal date. It works fine with the normal/standard date
In my file i have a date format is Wed 1 Sep and I need to convert this format to 2010-09-01. Although, year is missing but I can add this manually at the time of convert or just about before to convert.
Any suggestion are welcome or if you know any good way to import data from excel to sqlserver please share.
thanks for your help. Regards, Athar
View Complete Post