how to transfer data from excel to SQL server | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

how to transfer data from excel to SQL server

14th Feb 2020, 9:53 AM
Mwita Mike
Mwita Mike - avatar
3 Answers
0
thanks
21st Feb 2020, 3:52 PM
Mwita Mike
Mwita Mike - avatar
+ 2
You can do through any intermediate programming language like Java. You can read data from Excel file and store in database. Here is given how to read Excel file in java. https://www.google.com/amp/s/howtodoinjava.com/library/readingwriting-excel-files-in-java-poi-tutorial/amp/
14th Feb 2020, 10:56 AM
A͢J
A͢J - avatar
+ 1
Michael Mwita Did you search? Just passing the first result from Bing search on "import Excel to Sql Server" https://docs.microsoft.com/en-us/sql/relational-databases/import-export/import-data-from-excel-to-sql
14th Feb 2020, 11:30 AM
Ipang