![]() WRT recordset, I've had best luck using CursorType = adOpenStatic and LockType = adLockOptimistic. export to a CSV and import the CSV in your 64-bit Excel. Option 2: Re-install 32-bit Excel If re-installing 32-bit Excel is NOT an option, execute your queries in the SQLite CLI i.e. I use ADODB, the 32-bit driver with Excel 32-bit
0 Comments
Leave a Reply. |