Making Excel as Database

Help
1

I am new to VB.net coding. I searched everywhere. But didnt get what is the starting point of making excel as database.

Is there is need of installing OLEDB Driver externally. and how can we do that for using excel as database so that SQL queries can be run on this.

Regards

2

@ChitraPal OLEDB will be nstalled along with .net environment, so you no need to install externally. U need connection string and provider name along with excel path to connect excel as database. you can perform select, insert, update operations on excel but u can’t perform delete operation, it might be included in higher version.

5 Likes
3

Thanks @Manjuts90 I tried same and it helped alot.

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.