database-js-adodb

const Database = require('database-js2'); // database-js2 is a peer dependency for primary use case (async () => { let connection, statement, rows; const dbPath = process.env.DB_PATH || 'C:\\Users\\me\\Desktop\\access_db.mdb'; // Example path, adjust as needed const connectionString = `database-js-adodb:///${dbPath}`; try { // Connect to the ADODB source via database-js connection = new Database(connectionString); // Prepare and execute a parameterized query statement = await connection.prepareStatement("SELECT * FROM tablea WHERE user_name = ?"); rows = await statement.query('not_so_secret_user'); console.log("Query Results for Access DB:", rows); // Example for Excel (version 8) connection const excelPath = process.env.EXCEL_PATH || 'C:\\Users\\me\\Desktop\\excel_file.xls'; // Example path, adjust as needed // Note: Extended Properties must be correctly escaped within the connection string const excelConnectionString = `database-js-adodb:///${excelPath}?Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';`; const excelConnection = new Database(excelConnectionString); const excelStatement = await excelConnection.prepareStatement("SELECT * FROM [Sheet1$A1:C52] WHERE user_name = ?"); const excelRows = await excelStatement.query('another_user'); console.log("Excel Query Results:", excelRows); await excelConnection.close(); } catch (error) { console.error("An error occurred:", error); } finally { if (connection) { await connection.close(); } } })();