I have a script that queries and updates an access table. I've used it successfully on my computer, but after installing anaconda and spyder on a different computer (same versions as the original installation on the original computer) it doesn't work on the new computer.
To clarify: I installed the package using
pip install sqlalchemy-access
on the anaconda prompt, and when running
pip list|findstr access
I get
sqlalchemy-access 1.1.3. However, when I run the script in spyder I get the NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:access.pyodbc error.
NoSuchModuleError: sqlalchemy-access
413 views Asked by Nitzan At
2
There are 2 answers
Related Questions in PYTHON
- How to store a date/time in sqlite (or something similar to a date)
- Instagrapi recently showing HTTPError and UnknownError
- How to Retrieve Data from an MySQL Database and Display it in a GUI?
- How to create a regular expression to partition a string that terminates in either ": 45" or ",", without the ": "
- Python Geopandas unable to convert latitude longitude to points
- Influence of Unused FFN on Model Accuracy in PyTorch
- Seeking Python Libraries for Removing Extraneous Characters and Spaces in Text
- Writes to child subprocess.Popen.stdin don't work from within process group?
- Conda has two different python binarys (python and python3) with the same version for a single environment. Why?
- Problem with add new attribute in table with BOTO3 on python
- Can't install packages in python conda environment
- Setting diagonal of a matrix to zero
- List of numbers converted to list of strings to iterate over it. But receiving TypeError messages
- Basic Python Question: Shortening If Statements
- Python and regex, can't understand why some words are left out of the match
Related Questions in SQLALCHEMY
- SQLAlchemy 2 Can't add additional column when specifying __table__
- The selection of specific columns in SQLAlchemy in scalars does not work
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- SQLAlchemy Many-to-Many Relationship: UNIQUE constraint failed
- SAWaring when using a Mixin to make SQLAlchemy Objects
- Incompatibility error in SQLAlchemy. Is there anything I am doing wrong or haven't done?
- Optimize multiple SQLAlchemy queries to one query
- SQL Alchemy custom type, forcing blob bind parameter
- postrgres/psycopg: cannot insert multiple commands into a prepared statement
- Error installing MySQLdb with pipenv on Ubuntu 23
- Why is query via SQLAlchemy session slower on first run
- I am trying to connect my Aiven database to python using the SQLalchemy module
- How do I use class in SQLAlchemy. I have being trying to use class but the table is not creating
- Why does Dataframe.to_sql() slow down after certain amount of rows?
- How to detect changes in custom types in sqlalchemy
Related Questions in SPYDER
- Is there a way to deactivate (but not delete) conditional breakpoints when debugging?
- A given package is installed but spyder won't see it
- Seem to have broken Spyder via Anaconda update (?)
- Old python program no longer works after updating Pi3 to Pi4
- Python code stopped working without any changes in code. Installing older version of packages doesn't help. What changed?
- Spyder works, Anaconda cannot be opened
- Corrupted image when saving imshow as PDF with matplotlib
- How do I import turtle in Spyder?
- Spyder or Jupyter? for Qiskit
- Linux-to-Linux IPython kernel connection over ssh failing where Windows-to-Linux works
- I can't make matplotlib work on jupyter (chromebook)
- Spyder 5.5.2 crashes with RuntimeError: wrapped C/C++ object of type SpyderKernelManager has been deleted
- Wait for asyncio.create_task to get results in Spyder IDE
- Spyder console not working after installing into spyder-env using Miniconda after a fresh Ubuntu Studio install
- broken anaconda after windows update
Related Questions in SQLALCHEMY-ACCESS
- How to store Pandas DataFrame with Int64 to MS Access table
- Python ,SQLalchemy, Access dbs error pop up when turn it to an exe file
- "COUNT field incorrect" error when column name contains a question mark
- SQLAlchemy Error: has_table() got an unexpected keyword argument 'info_cache' encountered
- Write large pandas dataframe into .accdb
- Pyodbc error after upgrading python from 3.8 to 3.11
- Pyodbc.OperationalError HY001 when trying to delete rows from MS Access through SQLAlchemy-Access in Python
- How to import a directory of excel files into MS ACCESS with python?
- sqlalchemy-access: Table already exists
- NoSuchModuleError: sqlalchemy-access
- How can I write a pandas dataframe into an Access database using pyodbc?
- Query filter using CDate() produces inconsistent results
- Upserting rows in access table from pandas dataframe using sqlalchemy
- Pyodbc Connection to Access, creating table with Pandas to_sql(method='multi') throwing errror
- Python: Something other than pyodbc or a workaround when importing data into Access table
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
I don't know why, but after trying multiple times, I checked again (
pip list|findstr access) and found that the installation of sqlalchemy-access, which I managed to find before in the anaconda prompt, has disappeared. I installed it again (for the third or fourth time) and now it works.