如何使用JavaScript访问Access数据库？

npm install ado

const ado = require('ado');

const connectionString = 'Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\your\\access\\file.accdb;Persist Security Info=False;';

ado.connect(connectionString, (err, connection) => {
  if (err) {
    console.error('Error connecting to Access database:', err);
    return;
  }

  const query = 'SELECT * FROM your_table_name';

  connection.query(query, (err, results) => {
    if (err) {
      console.error('Error executing query:', err);
      return;
    }

    console.log('Results:', results);
  });
});

node access.js