importpypyodbcimporttimeimportpandas as pdimportnumpy as np
filepath= r'C:\Users\zzc\Desktop\ScreenToGif\Asset.mdb'to_filepath= r'C:\Users\zzc\Desktop\ScreenToGif\a.csv'
#连接mdb文件
connStr = (r'Driver={Microsoft Access Driver (*.mdb)};DBQ='+filepath+';'r'Database=Asset2')
conn=pypyodbc.win_connect_mdb(connStr)#connStr = (#r'Driver={SQL Sever};'#r'Server=sqlserver;'#r'Database=bill;'#r'UID=sa;'#r'PWD=passwd'#)#
#conn = pypyodbc.connect(connStr)#创建游标
cur =conn.cursor()
cur.execute('SELECT * FROM Asset2')#获取第一条数据,返回他的长度,也就是字段长度了
columns_len =len(cur.fetchone())#建立pandas,列数量就是上面字段数量
df = pd.DataFrame(columns=range(columns_len))
index=0for row incur.fetchall():#temp用来保存每一行的数据
temp =[]for columns inrange(columns_len):
temp.append(row[columns])
df.loc[index]=temp
index+=1
#print(df)
df.to_csv(to_filepath)ifconn:#无论如何,连接记得关闭
conn.close()