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 14, 2022, 5:11pm 4

Hi @AnuragJosh17

You need to install microsoft oledb provider for getting missing connections I believe

Please use below link

Please go through this

cheers

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

Excel as Database in xlsm/xlsb/xlsx

Related topics