Last week, there was an interesting thread on the PyWin32 mailing list about how to read Microsoft Access databases with Python without having Access actually installed. Vernon Cole had the solution, but I noticed that Google doesn’t seem to index the PyWin32 list very well, so I decided to write about it here. (more…)
Entries tagged with “microsoft access”.
Did you find what you wanted?
Tue 1 Feb 2011
PyWin32: adodbapi and MS Access
Posted by Mike under Python, PyWin32, Windows
[6] Comments
Sun 10 Oct 2010
SqlAlchemy and Microsoft Access
Posted by Mike under Python, SqlAlchemy, Windows
[5] Comments
Update (10/12/2010) – One of my alert readers told me that SqlAlchemy 0.6.x currently does NOT support the Access dialect. Read here for more info.
A year or two ago, I was asked to transfer some data from some old Microsoft Access files to our Microsoft SQL Server. Since I enjoy using SqlAlchemy, I decided to see if it supported Access. The documentation at the time was pretty unhelpful in this regard, but it did seem to be possible and I found one thread about it on SqlAlchemy’s Google group. (more…)