Images from MS Access 2003 to SQL Server 2008 R2 RRS feed

  • Question

  • Hello,

    In MS Access 2003 I have a table with an image in a field named "Picture". The field is an OLE Object in Access 2003.

    I used MS Import and Export Data (32) bit to move the table from MS Access 2003 into a database into MS SQL Server 2008 R2.

    The records comes over properly but the images do not.

    The field in the import changes to a "Image" in MS SQL Server 2008. All other data is correct but, it does not bring in the image at all.

    Is there something in the import that I can change to bring in the images properly?

    Thanks in advanced.
    Monday, June 18, 2012 8:19 PM


All replies