Access 2000 memo datatype to JDBC

Access 2000 memo datatype to JDBC

Post by elock.. » Wed, 29 Nov 2000 04:00:00

I'm trying to transfer an Access 2000 database to a Java based database
and I'd like to know what SQL or JDBC datatype to use for Access' Memo
type. Must I use the getUnicodeStream method or is there another method
I can use?


Sent via
Before you buy.


1. Access 2000 Memo DataType - URGENT


I am using an ADO Parameter Object to insert some text into a memo datatype
in Access 2000.  The ADO Command object which uses the Parameter Object
calls a Access 2000 query object.  Example below:

PARAMETERS prmCommentDesc Memo;
INSERT INTO Comment ( Comment )
VALUES (prmCommentDesc);

However the parameter datatype -  memo is not supported in query parameters
at the Access 2000 end.  Does any know what datatype I should using instead
of memo in the above query example?


2. SP turns slow suddenly without having modified it

3. Error while inserting memo datatype in Access

4. help please?

5. What datatype to use for Access memo fields?

6. SQL handle .dbf database file

7. SQL7 Datatypes for Access memo fields

8. 2cnd RFD: and ACK for comp.databases.clarion

9. Convert Access memo datatype to SQL Server text type

10. ADO and Access Memo datatypes

11. access Access 2000 vio jdbc-odbc bridge ?? code

12. TDS / Access 2000 and Memo flds

13. Importing Access memo fields to SQL Server 2000