dbf文件导入mysql

import dbf
import csv
import mysql.connector

# 读取DBF文件
table = dbf.Table('path_to_your_dbf_file.dbf')
table.open()

# 将DBF文件数据写入CSV文件
with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(table.field_names)  # 写入表头
    for record in table:
        writer.writerow(record.fieldData)

table.close()

# 连接MySQL数据库
cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
cursor = cnx.cursor()

# 创建MySQL表
create_table_sql = """
CREATE TABLE IF NOT EXISTS your_table (
    column1 datatype,
    column2 datatype,
    ...
)
"""
cursor.execute(create_table_sql)

# 导入CSV数据到MySQL
with open('output.csv', 'r', encoding='utf-8') as csvfile:
    reader = csv.reader(csvfile)
    next(reader)  # 跳过表头
    for row in reader:
        insert_sql = "INSERT INTO your_table (column1, column2, ...) VALUES (%s, %s, ...)"
        cursor.execute(insert_sql, row)

cnx.commit()
cursor.close()
cnx.close()