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!
New course! Every coder should learn Generative AI!
Try a free lesson
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 Answers
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