SQL Offline

Use SQL Offline to read and edit your tables and queries offline in a spreadsheet. You can later sync when you are ready (by creating SQL script or connecting through a client driver). While offline you can make simple edits, add columns, or (re)create a table. You can also create and test connection strings (UDL), perform common admin tasks (DDL), and difference check (Synch preview). Supports SQL Server, Windows Azure SQL Database, SQL Server CE (3.5 and 4.0), MySQL, Oracle, Postgre, SQLite(SQLITE), dBase (DBF, DBC), and others with a connection string (UDL). Supports Access (ACCDB, MDB) and Excel (XLSX, XLS) files if Microsoft Office 2008 or later is Installed.

Features include: *Offline edits (modify data); *Offline table admin (add columns and constraints); *Create and run SQL script (sync just a few cells, or recreate an entire table); *Difference check (sync preview); *Spreadsheet Data tools (merge, sort, combine); *Formulas and Macros (vbscript with document access); *Adaptive SQL Language (DML and DDL adjusts for different servers); *Create, test, and share connection strings (UDL files). SQL Offline supports most popular relational data files and database servers (complete list in the readme which includes installation instructions for client drivers).