Connecting Tech Pros Worldwide Help | Site Map

Remove Ole Objects From Table

  #1  
Old August 25th, 2007, 12:25 AM
Steve
Guest
 
Posts: n/a
I am working on a database with a table that contains several hundred
pictures stored as ole object data type. I want to remove the pictures from
the table, store them in a separate file and record the path to the file in
the database. How do you remove the pictures from the table and save them to
a file?

Thanks!

Steve


  #2  
Old August 25th, 2007, 12:55 AM
John Marshall, MVP
Guest
 
Posts: n/a

re: Remove Ole Objects From Table


Please contact www.pcdatasheet.com. They will do it to you for a reasonable
fee.

John... Visio MVP

"Steve" <sorry@private.emailaddresswrote in message
news:13cuq1bdl2d1r64@corp.supernews.com...
Quote:
>I am working on a database with a table that contains several hundred
>pictures stored as ole object data type. I want to remove the pictures from
>the table, store them in a separate file and record the path to the file in
>the database. How do you remove the pictures from the table and save them
>to a file?
>
Thanks!
>
Steve
>

  #3  
Old August 25th, 2007, 02:15 AM
Arch
Guest
 
Posts: n/a

re: Remove Ole Objects From Table


On Fri, 24 Aug 2007 19:22:17 -0400, "Steve"
<sorry@private.emailaddresswrote:
Quote:
>I am working on a database with a table that contains several hundred
>pictures stored as ole object data type. I want to remove the pictures from
>the table, store them in a separate file and record the path to the file in
>the database. How do you remove the pictures from the table and save them to
>a file?
>
>Thanks!
>
>Steve
>
I know a "resource" that can help you with this. His rates are very
reasonable.
  #4  
Old August 25th, 2007, 02:15 AM
Larry Linson
Guest
 
Posts: n/a

re: Remove Ole Objects From Table


"Steve" <sorry@private.emailaddresswrote
Quote:
>I am working on a database with a table that contains several hundred
pictures stored as ole object data type. I want to remove the pictures
from
Quote:
the table, store them in a separate file and record the path to the file
in
Quote:
the database. How do you remove the pictures from the table and save them
to
Quote:
a file?
Poor Steve. Didn't I caution you that blatant advertising was going to cut
you off from help from the very people best qualified to assist when you had
problems?

Hint: http://groups.google.com is your friend; the answer is not blowing in
the wind; it is in the archives of this database. Good hunting, Steve.

Larry


  #5  
Old August 25th, 2007, 11:05 AM
Arno R
Guest
 
Posts: n/a

re: Remove Ole Objects From Table



"Arch" <send.no@spam.netschreef in bericht news:i50vc31l42vbau8aldjjtf8goj3gkvib6j@4ax.com...
Quote:
On Fri, 24 Aug 2007 19:22:17 -0400, "Steve"
<sorry@private.emailaddresswrote:
Quote:
>>I am working on a database with a table that contains several hundred
>>pictures stored as ole object data type. I want to remove the pictures from
>>the table, store them in a separate file and record the path to the file in
>>the database. How do you remove the pictures from the table and save them to
>>a file?
>>
>>Thanks!
>>
>>Steve
>>
I know a "resource" that can help you with this. His rates are very
reasonable.
Since that resource is PCD and that guy is listed only as a Pretty Crappy Developer, that is *not* going to help ;-)

I am afraid Steve has to use one of his sockpuppets again.
To the group:
--Please be aware of questions regarding OLE-objects
--Please be aware of questions regarding extracting data from Outlook.
http://groups.google.nl/group/comp.d...e933139ae8a4a2


Arno R
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
are ado questions allowed here? MP answers 19 December 4th, 2005 02:55 AM
VB versus VB.NET timings!! Siv answers 25 November 21st, 2005 07:19 AM
Searching multiple tables in Access using Visual Basic Katrina answers 3 November 13th, 2005 09:10 AM
How to make composite unique index? deko answers 10 November 13th, 2005 07:42 AM