Community

Page Images Field Type on SQL Server table

Avatar
Written by Alberto Torino
  • 2
I need to export each document FileName and path along with field values to a SQL Server table. I've created a varchar field to store the document path&name. But when exporting i get an i "Column Page_Images of incompatible type". What type should it be? When exporting to a txt file, Page Images, export the file path. Does it work the same way when exporting to a Sql Server table?.
Thanks,
Regards

Was this article helpful?

0 out of 0 found this helpful

Comments

2 comments

Sort by Date Votes
  • Avatar
    Anastasiya Nechaeva
    Unfortunately it's know issue that the option "Save images into a database" is automatically changed to "Save images to folder" option during setting up export to a database using a wizard.

    You can try the next workaround:
    Open the Export Settings dialog and change the option back to the "Save images into a database", then check field mapping in the same name dialog box.

    Second please make sure that you choose recommended provider - OLE DB Provider for ODBC Drivers.
    0
  • Avatar
    Alberto Torino
    Found that setting "Image Export Settings" to folder and clicking "Create Tables" button creates a Page_Images field of type nvarchar(255). That worked fine for me.
    Thank you very much Anastasiya.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post