AccesSQL - VS Code Extension

A Visual Studio Code extension for executing SQL queries on Microsoft Access databases (.mdb, .accdb) with advanced features for data import/export from Excel files and visual database schema exploration.

Features

Hierarchical Database Explorer

3-Level Tree View - Navigate your database structure visually
- Level 1: Saved database connections (expandable)
- Level 2: Tables - both local and linked tables (expandable, color-coded)
- Level 3: Columns with data types (color-coded by type)
SharePoint Integration - Full support for SharePoint linked tables
- Displays SharePoint Lists as linked tables
- Works with SQL Server, Excel, and other ODBC linked tables
- Automatically filters out system tables (MSys*)
Quick Actions - Inline buttons for each connection
- Connect to database
- Delete saved connection
- Add new connection (tree title button)

Color-Coded Data Types

Red: Numbers (number, integer, currency)
Green: Text (text, memo)
Orange: Dates (date)
Blue: Local Tables
Purple: Linked Tables (SharePoint, SQL Server, Excel)
Yellow: Primary Keys (autonumber, guid)

Database Operations

SQL Query Execution - Execute SELECT, INSERT, UPDATE, DELETE queries
Connection Management - Save and manage multiple database connections
Table Explorer - View all tables and their column structure
UTF-8 Support - Full support for accented characters

Excel Integration

Excel Import - Ultra-fast bulk insert with performance metrics
- High-performance batch processing (50-100+ rows/sec)
- Dynamic batch sizing: 25-100 records based on column count
- Multiple INSERT statements in single transaction
- Real-time duration and speed tracking
- Automatic fallback to individual inserts on errors
- Progress tracking with percentage and success/failure counts
Excel Update - Bulk update records with conditional WHERE clauses
- One-by-one processing for precise WHERE conditions
- Row-level error tracking and reporting

Logging & History

Query History - Track all executed queries with success/failure status
Comprehensive Logging - Detailed logs in both OUTPUT panel and log files
Performance Metrics - Import duration and rows/sec statistics

Requirements

Operating System: Windows (uses PowerShell and ADODB COM objects)
Microsoft Access Database Engine - Included with Microsoft Office or download separately

License

Changelog

See CHANGELOG.md for version history and release notes.

AccesSQL

Santiago Perez Ruiz