用Java在CSV文件中写入MS Access表

import java.sql.*;
import java.io.*;

public class CSVtoAccess {
    public static void main(String[] args) {
        String csvFile = "path/to/csv/file.csv";
        String accessDB = "path/to/access/database.accdb";
        String tableName = "your_table_name";

        try {
            // 加载MS Access的JDBC驱动程序
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");

            // 建立与数据库的连接
            Connection conn = DriverManager.getConnection("jdbc:ucanaccess://" + accessDB);

            // 创建表格
            Statement stmt = conn.createStatement();
            String createTableQuery = "CREATE TABLE " + tableName + " (column1 DataType1, column2 DataType2, ...)";
            stmt.executeUpdate(createTableQuery);

            // 读取CSV文件
            BufferedReader br = new BufferedReader(new FileReader(csvFile));
            String line;
            while ((line = br.readLine()) != null) {
                // 拆分每行的字段
                String[] fields = line.split(",");

                // 插入数据
                String insertQuery = "INSERT INTO " + tableName + " VALUES (?, ?, ...)";
                PreparedStatement pstmt = conn.prepareStatement(insertQuery);
                for (int i = 0; i < fields.length; i++) {
                    pstmt.setString(i + 1, fields[i]);
                }
                pstmt.executeUpdate();
                pstmt.close();
            }
            br.close();

            // 关闭连接
            stmt.close();
            conn.close();

            System.out.println("CSV文件已成功写入MS Access表格。");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}