ADO connection, Execute method, and Excel VBA...

[Gedeon Kh]

Dear friends,

I'm creating an Excel Add-in that has several functions. Also I have a bid data in Access (more than 10 000 rows, and several tables).
The Add-in connects to DB when it opens. Then every function in the Add-in use RecordSets to read data from Access DB and do some calculations.

This method works. The problem is the speed )).
When I use a workbook that has lots of this Add-in functions, it works very slow And every time it takes several minutes to open the workbook.

Of course I could bring the data to Add-in worksheets, but this will overload the excel file.

So I would like to ask Excel/Access experts if there is another way to read the data and not to execute them every time with every function?

 

[james_lankford]

Thanks for the trick, this was faster.

But the value in Access is 8.1811, but excel returns it as 8.18109989166259:

I'm sure the number in Access is also 8.18109989166259

but if you round 8.18109989166259 you get 8.1811

so access is just formatting the number and showing you the rounded version

you can change the format in excel to also show the rounded version