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

AnuragJosh17 (Anurag Joshi) November 17, 2022, 6:11am 5

Thank you

Installing MC Access Database engine 32 bit solved this problem. Even though my system is 64 bit need to install 32 bit only.

1 Like

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