I have an XLS file which has a lot of merged cells and empty cells. When I save the file as a CSV, the merged cells are no longer merged, but the empty cells remain. When viewed in Notepad, there are commas without any values between them. How do I import such a file to MS SQL. Additionally, which query/command would be ideal if I were to import this file on a regular basis, say, daily? How do I import it dynamically and how can I perform a cleanup on the file?
Comment