<div>
Why aren't you using PyODBC, or similar?
</div>


<div>
OK, could you (or anyone else) post some sample code to return and query a recordset?<br />
<br />
Thanks.
</div>


OK, could you (or anyone else) post some sample code to return and query a recordset?

Thanks.

<div>
solutions provided by experts
</div>


<div>
<div class="content wysiwyg-content">
I have a table TABLEAA in a MS Access database and I want to retrieve the data into some Python code.<br />
<br />
I can connect to the database using win32com and run a query (SELECT, Z00, Z01, Z02, Z03 FROM TABLEAA) but how do I then refer to Z00, Z01 etc in the Python code? Here is my sample code...<br />
<br />
import win32com.client<br />
from win32com.client import Dispatch<br />
<br />
strDbName = r'C:\\Users\Ross\Documents<wbr />\TESTDB.md<wbr />b'<br />
objAccess = Dispatch(&quot;Access.Applicati<wbr />on&quot;)<br />
objAccess.OpenCurrentDatab<wbr />ase(strDbN<wbr />ame)<br />
<br />
objAccess.DoCmd.OpenQuery(<wbr />'AAQUERY')<wbr />
</div>
</div>


I have a table TABLEAA in a MS Access database and I want to retrieve the data into some Python code.

I can connect to the database using win32com and run a query (SELECT, Z00, Z01, Z02, Z03 FROM TABLEAA) but how do I then refer to Z00, Z01 etc in the Python code? Here is my sample code...

import win32com.client
from win32com.client import Dispatch

strDbName = r'C:\\Users\Ross\Documents\TESTDB.mdb'
objAccess = Dispatch("Access.Application")
objAccess.OpenCurrentDatabase(strDbName)

objAccess.DoCmd.OpenQuery('AAQUERY')

Retrieving data from a MS Access table using Python

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.