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.