![export data from firebird database to excel export data from firebird database to excel](https://www.databasetour.net/images/screenshots/exporting-multiple-tables-to-one-file.png)
SQL Image Viewer is for technical users who are comfortable writing SQL queries to retrieve the required data.Īccess OLE Export is for less technically inclined users who just want to be able to select a table and export their data quickly.īoth products can identify embedded Office document content, images, PDF content, Open Document content, and other common binary types. We have 2 products, SQL Image Viewer and Access OLE Export, that can remove the OLE wrappers for data stored in OLE Object fields, and export them to disk. This is a tedious process if you have a lot of records you need to extract. The usual way to extract the content is to open each item individually in Excel, and save them to files. Both records in the OLE Object fields have had additional OLE wrappers added to them. If you try to export the data as is, you will not be able to open the exported files, because the format itself is not Excel-compliant. The size of the attached file record is also larger than the original file size, because Access needs to add additional data to the file. Now if we take a look at the size of the 2 records using SQL Image Viewer, we can see that the size of the embedded workbook is larger than the attached file. In Access, we can open both workbooks easily simply by double-clicking on them. We create the first record by directly embedding an Excel workbook.įor the second record, we simply attach an existing Excel workbook. However, it is difficult to extract the data from those fields because of the additional OLE information embedded together with your data.įor example, let’s create a table in Access, and store a simple Excel workbook, first as an embedded object, and second as an embedded file. It is convenient because Windows handles how the files or documents are opened, modified, and saved via OLE servers.
![export data from firebird database to excel export data from firebird database to excel](http://www.firebirdmanager.com/images/Cap_data.png)
OLE Object fields are commonly used by applications using Access as the back-end database to store files and common document formats.