Post reply

Import Image stored in MS-Access to SQL Server 2000

  • April 26, 2009 at 12:34 pm

    #73608

    Hi All;

    I am .NET Developer, I have a question to ask that:

    How can I import Image stored in MS-Access to SQL Server 2000.

    Please Help Me ..

    Regards!!

  • April 27, 2009 at 4:06 am

    #984241

    Hi There,

    Could you clarify your request? For example, are you trying to import a single image into SQL Server or do you want to import an access table into SQL Server 2000?

    regards

    Quis custodiet ipsos custodes.

  • April 27, 2009 at 4:28 am

    #984245

    Hi;

    Actually I have a customer record table in Access (incliudes image field),

    and now i want to move database from access to sql server.

    i have done all the things except image column ...

    So i need help for this..

    Thanks !

  • April 27, 2009 at 4:45 am

    #984249

    Hi,

    An Access image is an OLE object and these carry some header data. The link below describes in detail how to extract the image from an OLE object. The example is in VB.Net but translating it to C# shouldn't be a problem.

    http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q175/2/61.asp&NoWebContent=1

    Once you have extracted the image, save it to SQL Server as an image datatype.

    regards

    Quis custodiet ipsos custodes.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply