Extracting Memo Fields in Access

[Palacios]

I have a problem with Access 2000 when extracting memo from an Oracle
database memo field. We are using Access 2000 as a front-end to extract
certain data fields from the Oracle database and dumping the results into
another table for distribution, one of the data fields is a memo field. This
process has worked in the pass four years up until about two weeks ago. We
are using a subroutine module to strip the memo data of all formatting codes
that are stored in the data field. Recently, what has been happening is only
part of the data is being dumped into our table. I don't recall any updates
to Access recently to assume as the cause of this problem. Anyone has any
suggestion?

 

[aaron.kempf]

use a real ETL tool.

Doesn't Oracle include a ETL tool?

SQL Server does!

-Aaron

 

[John W. Vinson]

I have a problem with Access 2000 when extracting memo from an Oracle
database memo field. We are using Access 2000 as a front-end to extract
certain data fields from the Oracle database and dumping the results into
another table for distribution, one of the data fields is a memo field. This
process has worked in the pass four years up until about two weeks ago. We
are using a subroutine module to strip the memo data of all formatting codes
that are stored in the data field. Recently, what has been happening is only
part of the data is being dumped into our table. I don't recall any updates
to Access recently to assume as the cause of this problem. Anyone has any
suggestion?

If you're just getting 255 bytes, be sure that the Memo field does not have
any Format property set, and that you aren't trying to sort by it.

 

[Palacios]

Thanks Aaron,
But we only get Oracle Client (bummer). I am sure that if I had Oracle
professional or even a full version, an ETL will be included.

 

[Palacios]

Thanks John,
I'll check the memo field size. I do know that we are not sorting by the
memo field. We are sorting by the primary key of who is assigned the memo
data to.