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.
Get started with SQL Image ViewerMake working with blobs easier - try SQL Image Viewer free for 14 days
Got a question?If you need help, or have any questions about SQL Image Viewer, please get in firstname.lastname@example.org
•identifies images and file types automatically•identify images and files stored in OLE Object columns•export embedded images to Excel spreadsheets•supports Access, Firebird, MySQL, Oracle, PostgreSQL, SQL Server, SQL Server Compact, SQLite, and ODBC data sources