View and export images and files from your databases using SQL Image Viewer

• identifies images and file types automatically • identify images and files stored in OLE Object columns • export embedded images to Excel spreadsheets • supports Access, MySQL, MariaDB, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources

How to name your exported files using values from other columns Let’s say you run a query that returns a column containing the file name, and another column containing the image data. You want to name the exported files using the values in the LargePhotoFileName column. In any of the Export options, on the Image and File Options page, simply enter the value <LargePhotoFileName> in the Naming convention item. You can also click on the ... button beside the Naming convention item to add the field name, and also other system values supported by SQL Image Viewer. How about numbers? Let’s say we have the following result set: We want to name our exported images using the values from the ProductID column. To do that, just enter <ProductID> as the naming convention. SQL Image Viewer will automatically add the appropriate file extension, depending on the exported file type. What if we want to format the values to a specific number of values, and add a ‘ID’ prefix? To format the number, use the format specifier, and as for the prefix, simply add it before the column name e.g. The exported files will then be named as such: Let’s take it one step further - let’s add the product number to the file name, and make everything neater by spacing the values out using underscores. Our naming convention simply becomes and our exported files: If you want to learn more about the custom naming convention, take a look at the help file topic here, or if you are have any questions, drop us a line at support@yohz.com.