Question: how to import large excel file into sql server?
Answer:  Know your file location! ... ,  Open up Visual Studio > File > New > Project > Integration Services > OK. ... ,  Drag a [Data Flow Task] onto the designer window and double click on the task.