In this article We will discuss How to upload all excel data into Sql Server database directly Without Using any Code.
In Sql Server there is a direct option exists to upload Excel file and it will Create the table automatically with datatype and which is much more faster as compared to Code.
Note:- To Import Excel File from Sql Server compulsory we need Microsoft Office installed on that System.
First login into your Sql Server and right click on your database -> Goto Tasks -> Click Import Data -> Click Next -> then Choose Data Source Which is given in below image and in data source select "Microsoft Excel".
In Sql Server there is a direct option exists to upload Excel file and it will Create the table automatically with datatype and which is much more faster as compared to Code.
Note:- To Import Excel File from Sql Server compulsory we need Microsoft Office installed on that System.
First login into your Sql Server and right click on your database -> Goto Tasks -> Click Import Data -> Click Next -> then Choose Data Source Which is given in below image and in data source select "Microsoft Excel".
-> Click Next
-> After that in Destination Select "Microsoft OLE DB Provider for SQL Server",Select Server Name, Select either Windows/Sql Server Authentication and accordingly Fill UserName/Password and select Database from DropDownlist and Click Next.
-> In the next Screen Choose First Radio Button and Click Next.
-> In the next Screen We need to Select CheckBoxes and accordingly the name will Create and We can edit the name also and click Next and each one will Create a Separate table.
-> In the next Screen Check the 1st Option and Click Next and Finish and after that it will take Some time to Create the table.
0 comments:
Post a Comment