What datatype to use for Access memo fields?

What datatype to use for Access memo fields?

Post by Kevin Diete » Sat, 29 Jan 2000 04:00:00



I am converting an Access database to SQL Server 7.0 and am not sure the
"memo" fields in Access are converting correctly.  What type should these
fields be in SQL Server?  Thanks

Kevin

 
 
 

What datatype to use for Access memo fields?

Post by Bob Pfeif » Sat, 29 Jan 2000 04:00:00


These are usually translated to the text type in SQL Server.  If the memos
aren't really long, you could consider a varchar which can hold up to 8KB
(depending on the size of the other columns in the row).

 
 
 

1. DataType - Using Memo fields in Word

Hi,

I made a Word-document, using the bookmark option, where I
can add text in from the SQL-database.

I made a program in VB6 wich contains code like this to
call the fields:

MyWordDoc.Bookmarks("Memo").Select
MyWordApp.Selection.TypeText (rs1.fields("Note"))

I had no problems with the normal fields, but it seems
that a field declared as a "Memo-field" isn't able to do
this.
Does anybody know a solution for this?

Thanks in advance,
Olivier

2. SQL Trace....

3. SQL7 Datatypes for Access memo fields

4. Need some Speed... Indexing problem.

5. access memo field using VB6

6. downloading latest ver of ODBC

7. Importing Access Memo Fields using ntext

8. multi-column primary key insert error ('duplicate' complaint)

9. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures

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

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

12. Can't populate Access Memo field using Win32 api

13. VB - ADO --> Access using memo Fields