Use Python to read and write Access and pythonaccess to read and write

Use Python to read and write Access and pythonaccess to read and write

When learning Python, we will encounter Access read/write problems. In this case, we can use the COM Component Access Function of the win32.client module to operate Access files through ADODB.

1. Import Module

import win32com.client

2. Establish a database connection

conn = win32com.client.Dispatch(r"ADODB.Connection")DSN = 'PROVIDER = Microsoft.Jet.OLEDB.4.0;DATA SOURCE = test.mdb'conn.Open(DSN)

3. Open a record set

rs = win32com.client.Dispatch(r'ADODB.Recordset')rs_name = 'MEETING_PAPER_INFO'rs.Open('[' + rs_name + ']', conn, 1, 3)

4. operations on the record set

Rs. AddNew () # Add a new record rs. Fields. Item (0). Value = "data" # The first record of the new record is "data" rs. Update () # Update

5. Use SQL statements to add, delete, and modify data

# Add SQL = "Insert Into [rs_name] (id, innerserial, mid) Values ('000000', 2, '000000')" # SQL statement conn. execute (SQL) # Execute SQL statement # Delete SQL = "Delete * FROM" + rs_name + "where innerserial = 2" conn. execute (SQL) # modify SQL = "Update" + rs_name + "Set mid = 2016 where innerserial = 3" conn. execute (SQL)

6. Traverse records

Rs. moveFirst () # move the cursor to the first record count = 0 while True: if rs. EOF: break else: for I in range (rs. fields. count): # field name: field content print (rs. fields [I]. name, ":", rs. fields [I]. value) count + = 1 rs. moveNext ()

7. Shut down the database

conn.close()

The above is all the content of this article. I hope this article will help you in your study or work. I also hope to provide more support to the customer's home!