Help with insert into SQL

Results 1 to 2 of 2

Thread: Help with insert into SQL

  1. #1
    Join Date
    Dec 1969
    Posts
    940

    Default Help with insert into SQL

    Hello,<BR><BR> I need to insert a large amount of data into a SQL Server 6.5 table. Similar to how this message board does. I noticed that this forum uses MS Access and this field is a "MEMO" type. I am using SQL and it has no "MEMO" type. So my question is how can I insert this into my SQL table. What is the SQL equivalant of a memo field. I tried "text" and "binary" But both give errors. PLEASE HELP.

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: Help with insert into SQL

    Use a text datatype.<BR><BR>INSERT INTO MyTable (TextField) VALUES(&#039this is a string that wil be stored in a field with datatype of text.&#039)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •