how to export ole links from access into a flat file or into Oracl

[Jim Jones]

I have Acess 2000. I need to translate the data in several table into Oracle.
I have one column that has a link to some .JPEG file that I need to have the
directory location tanslated with each record into the new database. Just
need to know if this is possible if it is how is the best way to do it.

 

[John Nurick]

Hi Jim,

I assume that you mean an OLE field (if it's a text or hyperlink field
the problem is trivial<g>). If so, to get at the location of the linked
file you have to get inside the contents of the OLE field.

The simplest way I know to do that is to use a BoundObjectFrame control
on a form, bound to the OLE field, and get the SourceDoc property for
each record. If you add a text field to the table, it's simple to write
code that navigates the form from record to record, putting the file
location into the new field each time.

After that you just need to use an append query to move the data,
including the new file location field but excluding the OLE field, into
the Oracle table.

On Thu, 9 Dec 2004 15:09:01 -0800, Jim Jones <Jim