Introduction

I needed a tool to run sql's on both access and ms-sql databases, Rather than use Access or Server Manager, I have developed a simple (yet effective) tool that allows you to view the database tables, Run SQL's on the database and Export these sql's as either text or "sql insert" statements. All independant of the actual database behind the scenes.

Other people were interested, So I put it on the web, This is similar to a tool I developed years ago. This is a full re-write from scratch using Borland's "Turbo Delphi 2006".

What Databases Can you Access

• Access/Jet Databases
• Visual Fox Pro
• MS SQL Server
• Any ODBC database
• Any DB With ADO driver (see ADOExplorer.ini for how to configure)

Features

• Connect to any compilant database
• View The Tables
• Run SQL and view the results
• Load and Run multiple sql's on a database
• Save Query Results as text or "mssql insert statements"
• Remembers sql's from previous sessions
• Logs all sql's run on the database, so you dont need to save them some where else, see the database.log file

Screen Shots

Click on each image to enlarge.

Download (What Do You Need, Its all free !!!)

• This application which is available here ADOExplorer.zip (~500Kb) Simply Unzip and Run ADOExplorer.exe)
• You may need the Microsoft Data Access Components (MDAC) 2.8" component set
• For Visual Fox Pro, you will need the Microsoft OLE DB Provider for Visual FoxPro 9.0
• Want the source, Its comming soon