Is it required to have excel installed to use OPENDATASOURCE? [closed]

Question

Is it required to have excel installed to use OPENDATASOURCE? [closed]

Navigation

#1 by (1 votes)

0

Good morning, in the following link I found the way to import data from an Excel to SQL Server:

However, since the application from which I am going to execute said command is in PHP, I would like to know if it is necessary that in the server where the code is, Office is installed, specifically Excel.

sql php sql-server

asked by Oscar Galvis 26.04.2017 в 17:43

source

1 answer

Entity framework Read an Excel file and show in datagrid in c # Optimize consecutive sql statements

score 1 · Answer 1

It is not necessary to have MS Excel installed on the server.

But you will have to install the driver Microsoft.ACE.OLEDB.12.0 driver (for versions 2007-2010) or Microsoft.Jet.OLEDB.4.0 (for versions 97-2003) to be able to import.