Tag Archives: Access OLE Import

Using Access OLE Import

Access OLE Import is a Windows application that uploads files into OLE Object-type fields in your databases.  Most of the time, we are uploading into Access databases, but it can also be  client server databases like SQL Server, PostgreSQL, MariaDB/MySQL because Access is popularly used as a front-end to these databases.

Backup, backup, backup

The first step is the most important – back up your database first.  Access OLE Import makes changes to your tables, and having a backup lets you revert to a working database if anything goes wrong.

Preparing the data file

The next step is to prepare a data file.  This is an Excel worksheet containing the data to upload.  If you only want to insert files into a table, your data file would contain a single column, where the column header defines the field name to upload into and the filecontent identifier so that Access OLE Import will upload the contents of the listed files.  E.g.

Here, we want to upload the contents of the listed files into the document field.

If we want to update existing rows, we will need to provide one or more key values e.g.

Here, we are providing the definition that documentID is an integer-type key value.

Note that you can also use Libre Office or Open Office to create the data file.  You just need to save the spreadsheet in the Excel format (xlsx or xls).

Run the Upload Wizard

Probably the easiest step.  Connect to your database, enter the name of the table you want to upload into, select the data file, upload type, object type, and you’re done.

See also:

Introducing Access OLE Import

Access OLE Import is our new product that helps you upload files into OLE Object-type fields in Access and most major database engines (SQL Server, PostgreSQL, MariaDB/MySQL etc), for use in the following scenarios:

  • you are migrating data to a database that uses OLE Object fields
    E.g. you have a new customer that require their data to be migrated to OLE Object fields in your database.  Access OLE Import can upload the files into those fields easily.
  • you need to modify the existing data then upload the changes back into the tables
    E.g. you want to extract images from your database, then resize/add watermarks, then upload these updated images.  Use SQL Image Viewer to extract the images, modify them, then use Access OLE Import to upload the files.
  • you need to update file links in the OLE Object fields
    E.g. you have existing file links that are no longer valid, and want to update those file links.  Access OLE Import can upload file links as well as embedded files.
  • you want to convert embedded content to file links in OLE Object fields
    Use Access OLE Import to easily upload file links to replace the existing embedded content.

You can read more about Access OLE Import on this page, or download a 14-day trial.

See also: