用于将CSV导入Access的Java代码

您好！您的问题是关于将CSV导入Access的Java代码。以下是一个简单的Java代码示例，用于将CSV文件导入到Access数据库中。

import java.sql.*;
import java.io.FileReader;
import java.io.BufferedReader;

public class CSVtoAccess {
    public static void main(String[] args) {
        String url = "jdbc:ucanaccess://path/to/access/file.accdb";
        String username = "username";
        String password = "password";
        String csvFilePath = "path/to/csv/file.csv";
        String tableName = "table_name";

        try {
            // Load the JDBC driver
            Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");

            // Establish a connection to the Access database
            Connection conn = DriverManager.getConnection(url, username, password);

            // Create a statement object
            Statement stmt = conn.createStatement();

            // Create the table in the Access database
            stmt.execute("CREATE TABLE " + tableName + " (column1 datatype, column2 datatype, column3 datatype)");

            // Read the CSV file
            BufferedReader br = new BufferedReader(new FileReader(csvFilePath));
            String line;
            while ((line = br.readLine()) != null) {
                // Split the line by commas
                String[] values = line.split(",");

                // Insert the values into the Access database
                stmt.execute("INSERT INTO " + tableName + " (column1, column2, column3) VALUES ('" + values[0] + "', '" + values[1] + "', '" + values[2] + "')");
            }

            // Close the connection to the Access database
            conn.close();

            System.out.println("CSV file successfully imported to Access database.");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

请注意，您需要将上述代码中的以下变量替换为您自己的值：