Upsizing with picture data

[wschlichtman]

I am attempting to upsize a database from Access 2003 to SQL Server 2005
Express. All tables, indexes, relations, etc. are correctly upsized, except
one table refuses to cooperate.

This table is an OLE object field, which contains picture data. If I remove
this field, the table can be upsized. Apparently, the upsizing wizard is
unable to make the transition.

Is there a way around this dilema?

 

[AL FINK]

create the table with out the old field then create a append query and add
the field use the image data type.
now you can append the missing data

Hope this helps

 

[wschlichtman]

Ohhhhh, I hate those simple answers (bang head on keyboard). Thanks Al.