Member-only story

How to import data from excel sheet to database

Kajasumanie Kanapathipillai
1 min readDec 14, 2017

--

In Your Microsoft SQL Server Management Studio go to your database then right click on that then task=>import Data => select the Data source and excel file path =>ok. There may be a error ,We have to download AccessDatabaseEngine_X64 or X32 then we can import.

Download link:https://r.search.yahoo.com/_ylt=A0SO8yJ_HzJaS7IAXgpXNyoA;_ylu=X3oDMTExa2MyY3N1BGNvbG8DZ3ExBHBvcwMxBHZ0aWQDVUlDMV8xBHNlYwNzcg--/RV=2/RE=1513263104/RO=10/RU=https%3a%2f%2fwww.microsoft.com%2fen-us%2fdownload%2fdetails.aspx%3fid%3d54920/RK=2/RS=ZcrxWJw0pIxhTrf7UyphZu1yA1Y-

--

--

No responses yet