Import Image stored in MS-Access to SQL Server 2000

Question

Import Image stored in MS-Access to SQL Server 2000

igsri

SSC Veteran

Points: 206
More actions
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!!

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

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

Shaun Stewart SSC Eights! Points: 890 More actions · Answer 1

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.

igsri SSC Veteran Points: 206 More actions · Answer 2

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 !

Shaun Stewart SSC Eights! Points: 890 More actions · Answer 3

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">

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.