Defining a memo field (ms access) in SQL

[incagold]

Hi everyone,

Another newbie question. Is there a way to define a memo field, such as found in an ms access table, in SQL? We are developing a series of tables which will draw data from access. Some of the fields are memo type in access. Being new haven't found a way to get around this.

Thank you all in advance for any assitance.

REF

 

[hneal98]

In SQL, it is the TEXT data type.

 

[incagold]

Hi hneal98,

Thanks for the rapid response. Tried using text on an example table and it worked fine. Appreciate your help. Someday we will move beyond the newbie state.

REF

 

[hneal98]

No problem.