Can we import a table in a database in sql directly from excel instead of creating the table in sql ? i yes, how? | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
0

Can we import a table in a database in sql directly from excel instead of creating the table in sql ? i yes, how?

1st Aug 2016, 10:15 AM
Anand Nain
Anand Nain - avatar
3 ответов
0
in sql server it can possible I don't know about other
1st Aug 2016, 4:10 PM
ashwath nm
ashwath nm - avatar
0
It depends how you manage your database. With phpmyadmin, sqlbuddy or adminer for example you can import data from csv, xlsx and others files
1st Aug 2016, 7:17 PM
Martin Hübner
Martin Hübner - avatar
0
yes we can import tables into existing database there is a option in SQL Server to import table from various sources
2nd Aug 2016, 9:07 AM
Akshay Thakre
Akshay Thakre - avatar