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 14, 2022, 10:10am 3

Hi Anil thanks for your reply.

I saw people using MS Excel Driver which has xlsx,xlsm or xlsb

but in my license it is only showing MS Excel Driver which has xls

How to get that as a option which driver I need to install

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