I've been searching for hours and have found literally thousands of articles that mention the problem of Access Memo fields and Oracle, but none that offer any solution.
I need to do some automation for someone based on some data they have in an Access 2002 Database. I have an Oracle 9i database and have set up a table for him to dump data into so I can write a script to do the work.
Everything works fine except for a Memo field that contains data critical to the automation. Many records are longer than 255 characters and some are over 1000, so I understand the usual suggestion of changing the Memo to a Text field won't work. I originally had my corresponding field as a VARCHAR2(2000) field, but changed it to a LONG with no change.
Can anyone tell me if there is a way, inside an Access append query, to convert the Memo field text into a format that Oracle will accept?
_________
Rott Paws
...It's not a bug. It's an undocumented feature!!!
I need to do some automation for someone based on some data they have in an Access 2002 Database. I have an Oracle 9i database and have set up a table for him to dump data into so I can write a script to do the work.
Everything works fine except for a Memo field that contains data critical to the automation. Many records are longer than 255 characters and some are over 1000, so I understand the usual suggestion of changing the Memo to a Text field won't work. I originally had my corresponding field as a VARCHAR2(2000) field, but changed it to a LONG with no change.
Can anyone tell me if there is a way, inside an Access append query, to convert the Memo field text into a format that Oracle will accept?
_________
Rott Paws
...It's not a bug. It's an undocumented feature!!!
