I would probably write an INSERT/UPDATE trigger that would update the field to '0' + field if LEN(field) = 1.

Check this on support.microsoft.com

Microsoft Knowledge Base Article - Q258038

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO Stream Object

Steve,

I found this MS example of using the ADO stream with VB. Support.microsoft.com

Microsoft Knowledge Base Article - Q258038

HOWTO: Access and Modify SQL Server BLOB Data by Using the ADO...

You should set the Range object to the location of the starting cell.

Example: Range("A2").Select

I would suggest that you record macros and perform certain tasks, then stop the macro and look...