Exporting from Access2000 tables with OLE objects

[glimpse79]

Hi to all, the topic title say all: how can i export an access table
countaning OLE objects (embenned images) to another DB (in my case
postgresql)?

Thanks to all,

Luca

 

[Rob Schneider]

Don't know about the OLE objects. Never tried that. Check the
PostgreSQL documentation if they have a field type defined for that, or
check if the binary field types they have will work. Try and test.

For rest, a number of approaches
- connect to the PostgreSQL db with an ODBC driver and then just use
Access to query out of Access MDB into the PostgreSQL db.
- export the data from Access to text format, then import text into
PostgreSQL db.

I recall noticing that some of the books on PostgreSQL have chapters on
important data. Go take a look at some of them, e.g. the books from
O'Reilly.

Hope this is useful to you. Let us know.

rms