python中使用access数据库_用python读写access数据库表

您可以将表格转换为csv，以便用excel打开它

试试这个：import csv

roomnumber = 0.00

roomname = 0.00

lueftungList = []

import time

class Lueftung:

def getData(self):

global roomnumber

global roomname

roomnumber = input("roomnumber: ")

roomname = input("roomname : ")

myFormattedList = [ '%.2f' % elem for elem in lueftungList ]

def main(self):

global roomnumber

global roomname

lueftungList.append(["", roomnumber, roomname, "", ""])

lueftungList.insert(0,[(time.strftime("%d.%m.%Y")), "roomnumber", "roomname",])

# convert to csv

with open("lueftung.csv", "w", newline="") as csvfile:

cwriter = csv.writer(csvfile, delimiter=";")

for row in lueftungList:

cwriter.writerow(row)

if __name__ == "__main__":

luft = Lueftung()

luft.main()