Link to home
Start Free TrialLog in
Avatar of viroz
viroz

asked on

Copy "Long binary Data"

I have a database where i store images (OLE OBJECT) and the field inside the table has the value "Long Binary Data".
I am trying to copy everything to another database and i would like to copy the field which stores the images as Long Binary Data.
Is there a way to do this ?

Thanks in advance
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Hi viroz,

A regular copy or append query should work

Gary
Avatar of viroz
viroz

ASKER

No right click "Copy" available.
SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of viroz

ASKER

Ijust want to copy seperate fields. Is there a way to do this ?
Filter (on the ID) for the record you want & then select the column
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial