3 ms·
It's been well over a decade since I last dealt with Excel, but I remember you could actually query the data with SQL without opening the file, like you would w
by nutrie 2y ago
It's been well over a decade since I last dealt with Excel, but I remember you could actually query the data with SQL without opening the file, like you would with any flat-file db. If the size is the problem. It was poorly documented but I'd done it a few times and it worked really well. The best part being it was simple, fast and worked even with locked files. Otherwise I don't understand the question.
- taspeotis 2y agoYes, Microsoft.ACE.OLEDB.##.0