I am facing some problem with inserting data from excel file to sqlserver database table. kindly suggest me what i need to do?
i.e. i am having bulk copy of data in various excel files. from that excel files, only selected fields of data would be inserted into sqlserver database table.
how can i achieve this functionality manually.
kindly give me reference sites & suggestions.
Thanks in Advance