I want to use xlsx/xlsb/xlsm file as database but the format it accept is only xls. Is there any way using these files without disturbing there format since converting format may damage functionality inside file

Hi @AnuragJosh17 You need to install microsoft oledb provider for getting missing connections I believe Please use below link [image] Microsoft Access Database Engine 2016 Redistributable This download will install a set of components that can be used to facilitate transfer of data be…

Excel as Database in xlsm/xlsb/xlsx

Help Activities

Anil_G (Anil Gorthi) November 13, 2022, 6:44pm 2

Hi @AnuragJosh17

Please find below the connection strings for other excel formats as well. Hope this helps

cheers

Topic		Replies	Views
Getting error Connection String of Excel as Database Help	4	4810	October 4, 2019
Excel as Database - how to access without opening excel Help	13	5457	August 22, 2019
Database Connection with excel Studio studio , question , activities_panel	2	837	August 17, 2023
Use excel as Database Studio excel , database , studio , question	2	1310	October 4, 2023
Connecting excel with oledb and odbc providers Help database , activities	1	4708	December 21, 2017

Excel as Database in xlsm/xlsb/xlsx

Related topics