how to transfer data from excel to SQL server | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
0

how to transfer data from excel to SQL server

14th Feb 2020, 9:53 AM
Mwita Mike
Mwita Mike - avatar
3 ответов
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