This topic is locked
[SOLVED]

  Importing Images in MS SQL

6/18/2012 4:13:04 PM
ASPRunnerPro General questions
author

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.
Joe

1312 6/18/2012

Wrong Forum.. My apologies.

Joe