SQL Binary Tool

Save and load binary and text column data by referencing a file in a SQL statement
1.1, 2005-07-02

Usage

  1. Run sqlbinary.hta.

  2. Click Connect to choose an ODBC data source.

  3. Select a database.

  4. Browse for or type a file to read from to write to.

  5. When saving a file to a field, select the field type (e.g. MSSQL text is LongVarChar), and length (if necessary).

  6. Type select query to save field contents to a file. Type an insert or update query (using ? as a placeholder for the file) to save file contents to a field.

  7. Click Go.

Setup

  1. Make sure that you have all the requirements installed on your system.

  2. Download sqlbinary.hta to whereever you want to run it from on your workstation.