A Microsoft Access dialect for SQLAlchemy.
As noted on the PyPI project page:
This dialect is mainly intended to offer pandas users an easy way to save a DataFrame into an Access database via
to_sql.
Questions tagged [sqlalchemy-access]
27 questions
0
votes
0 answers
Write large pandas dataframe into .accdb
I have very large dataframe I'd like to directly write into a MS Access Database.
My current approach looks like this
import pandas as pd
from sqlalchemy import create_engine
from sqlalchemy.engine import URL
accdb_path =…
hyperinfer
- 39
- 1
- 1
- 5
0
votes
0 answers
Pyodbc error after upgrading python from 3.8 to 3.11
I am using the following code:
import pandas as pd, pyodbc
from sqlalchemy import create_engine
import urllib
def connStrMDBV2(fname):
driver = r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}'
connection_string =…
Zanam
- 4,607
- 13
- 67
- 143
0
votes
1 answer
Pyodbc.OperationalError HY001 when trying to delete rows from MS Access through SQLAlchemy-Access in Python
May I seek your help on an error I have met when I tried to delete all records marked "Y" in "Dummy Rows Indicator" column in Data table of one MS Access file?
The python script is as below.
import sqlalchemy_access as saa
import sqlalchemy as…
To_nY
- 1
- 1
0
votes
0 answers
How to import a directory of excel files into MS ACCESS with python?
I have been trying to import multiple files into MS Access with python but keep getting the following error:
DBAPIError: (pyodbc.Error) ('HYC00', '[HY00] [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented (106)…
John Mark Johnson
- 21
- 5
0
votes
0 answers
Problem pip installing sqlalchemy-access due to a "Could not fetch URL" error
I'm using Jupyter notebooks with 32-bit Python. I'm using pip 21.2.4 and Python 3.9. When I try to install sqlalchemy-access
pip install sqlalchemy-access
I get these errors,
Could not fetch URL https://pypi.org/simple/sqlalchemy-access/: There was…
Bojan Milinic
- 93
- 1
- 1
- 7
0
votes
2 answers
NoSuchModuleError: sqlalchemy-access
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…
Nitzan
- 33
- 5
0
votes
0 answers
Upserting rows in access table from pandas dataframe using sqlalchemy
I have an access table I am trying to update from a dataframe (I am having a lot of difficulty with the sqlalchemy syntax, so the following code may be very clunky with redundancies):
import pandas as pd
import pyodbc
import urllib
from sqlalchemy…
Nitzan
- 33
- 5
0
votes
0 answers
Are there exist any alternatives for mdbtools which doesn't use Java?
So I am tried to work with MsAccess DB file at Linux systems (Ubuntu 20.04 and CentOs 8) using Python and SqlAlchemy. And can't get to work mdbtools driver even with the simpliest query. At my home Ubuntu I installed latest sqlalchemy_access,…
Yuri
- 135
- 10
0
votes
1 answer
How to get list of objects from multi-value field with SqlAlchemy using ORM?
I have MS Access DB file (.accdb) from my client and need to describe tables and columns with declarative_base class. As I can see in table constructor - one of column has Integer value and has relationship "one-to-many" with another column in some…
Yuri
- 135
- 10
0
votes
1 answer
PyInstaller not including sqlalchemy-access module
I am trying to write a Dataframe back into a Access database file .mdb or .accdb. I am using sqlalchemy and sqlalchemy-access to create a connection.
import sqlalchemy
db_file_path = os.path.join(dir_path,…
MichaelMMeskhi
- 659
- 8
- 26
0
votes
1 answer
Read a Zip file from URL and convert a Ms Access file to data frame
I' writing this message to ask help in order to find a solution for this python code. I'm trying to generate a visualization of FAA PMA Parts in comparison with my company's parts database.
I've already done it using Power Bi, SQL Query and Excel…
Tfmr_uk
- 80
- 6
-1
votes
1 answer
"COUNT field incorrect" error when column name contains a question mark
This error seem to point to date columns in my dataframe. I know that this error appears when I try to do df_tosql in MS Access with unconverted date columns.
Im trying to fix this error by checking other date columns that I didnt include in…
user11956646