Excel ODBC Driver limitations

Request for clarification regarding points on the Denodo Reference manual. https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/odbc_sources/odbc_sources > The Excel ODBC driver provided by Microsoft Windows has some limitations: > > It cannot delete data from Excel spreadsheets. It can only query them and append more data. > > The Excel driver of Microsoft Excel 2003 or earlier, can execute only one query simultaneously. This can be a problem if we are combining data from the same Excel file. > > The newer versions of the Excel driver do not have this limitation. Which limitation does "The newer versions of the excel driver do not have this limitation" refer to? Is both limitations or just the bottom one?
user
19-07-2018 21:45:18 -0400

1 Answer

Hi, For establishing connections to Excel files, I’d strongly recommend to use Excel as a data source option. In [Excel Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/excel_sources/excel_sources) of the Denodo documentation you can find a detailed description on how to create Excel data sources. The limitation referred to is the bottom one. So, Excel drivers versions newer than 2003 can execute multiple queries simultaneously. Hope this helps!
Denodo Team
23-07-2018 07:22:19 -0400
You must sign in to add an answer. If you do not have an account, you can register here