如下图将Access数据写入到excel里面:
结果:
win32com使用ado+sql查询方法获得数据并写入excel.
# -*- coding: utf-8 -*-
"""
Created on Mon Dec 24 19:56:24 2018
@author: Fanxiaolei
"""
from win32com.client import Dispatch
from openpyxl import Workbook
cnn=Dispatch('ADODB.Connection')
rst=Dispatch('ADODB.Recordset')
cnn.Open('Provider=microsoft.Ace.oledb.12.0;data source=D:/Python_Practise/math2018.mdb')
rst.Open('select * from test',cnn,1,3)
if not rst.EOF:
ar=rst.GetRows()
wb=Workbook()
ws=wb.active
ws.append([rst.Fields[i].Name for i in range(rst.