Answers for "import excel to 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:\temp\MySpreadsheet.xlsx',
                        'SELECT * FROM [Data$]')

Posted by: Guest on March-08-2021

Code answers related to "import excel to sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "import excel to sql"

Code answers related to "import excel to sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "import excel to sql"

Code answers related to "import excel to sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us