Answers for "import excel file in my sql"

import excel to sql

You can also use OPENROWSET to import excel file in sql server.

SELECT * INTO Your_Table FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
                        'Excel 12.0;Database=C:tempMySpreadsheet.xlsx',
                        'SELECT * FROM [Data$]')

Posted by: Guest on March-08-2021

sql query to import data from excel to mysql

$ mysql -u root -p --local-infile
mysql> create database boatdb;
mysql> use boatdb;

Posted by: Guest on March-02-2021

Code answers related to "import excel file in my sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "import excel file in my sql"

Code answers related to "import excel file in my sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "import excel file in my sql"

Code answers related to "import excel file in my sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us