JDBC Inserts into Access 97 Memo Field

JDBC Inserts into Access 97 Memo Field

Post by Mike Hewit » Wed, 01 Apr 1998 04:00:00

I am working on a project collecting keyword-delimited text data,
parsing it, and populating an Access database.

My problem, however, is that one of the datafields can be quite large
(5000+ characters) and my 'INSERT INTO' statement gives me a syntax
error.  I can insert all of the other non-memo fields, but when I ad the
memo field it errors out.

I guess my question is - how long can I make the insert statement? I
have already tried removing the single quote, double quote, and
parenthese characters, to see if that was the cause of the error.

Any ideas?

Thanks in Advance,
- Mike Hewitt


1. Access 97, Delphi 3.02 and the Memo field ...

I got some trouble to put value into a memo field in Access.

My first try was :

MyQuery.ParamByName ('Field').AsMemo := sValue ;

And it works fine on MS SQL Server 7.0 & 6.5
Of course on Access I got an External exception EEFACE and my program hangs.

So, like help says I've tried :

MyQuery.ParamByName ('Field').AsString := sValue ;

The field content looks like garbage ...

Any clue ?


2. Pivot Table problem

3. ADO Update (using VB) of Memo fields in Access 97 DB

4. Export parfile variables

5. Displaying Memo Fields From Access 97 on VB Forms

6. pgsql-server/ oc/src/sgml/ref/pg_dump.sgml oc/ ...

7. Importing Access 97 memo fields into Oracle 8 [HELP]

8. LOCAL SHARE for DBase

9. Inserting LARGE Strings into ACCESS 97 via jdbc:odbc

10. JDBC-ODBC and MS Access MEMO Field

11. Using ADO Command object and Access PROCEDURE to insert Memo/Binary fields

12. How to relate a field to another field in the same Access 97 table