Unable to import sqlite3 using Anaconda Python

python-3.x windows sqlite anaconda importerror

I got this working on windows by downloading: the sqlite3 dll (find your system version)

And putting into the folder: C:\Users\YOURUSER\Anaconda3\DLLs

(Depending on how you installed Anaconda, this may have to be placed intothe following folder: C:\ProgramData\Anaconda3\DLLs)

python-3.x windows sqlite anaconda importerror

Locate the sqlite3.dll file. In my case it was in following folder

C:\Users\Admin\anaconda3\Library\bin

where C:\Users\Admin\anaconda3 is the folder where Anaconda was installed

Add this to PATH in environment variables, and it should work then.

python-3.x windows sqlite anaconda importerror

Please check https://github.com/jupyter/notebook/issues/4332I added anaconda root/Library/bin to my PATH and now it works!

CodeHunter