sql datatypes for stored procedures

Originally posted by : Drew (dfrank@san.rr.com)I want to create a stored procedure to inesrt text into a field of my MS Access 2000 database. I created the field as Memo type in access since that is supposed to be able to contain up to 65000 characters. In my stored procedure, however, i don't know what datatype to make the paramater that I am going to to insert into that field. I tried Text, and it threw an error if i tried over 256 characters. I also tried varchar(20000), and that allowed me to enter somewhere around 800 characters without throwing an error. What is the correct data type to use to support 10000 or so characters? thankS!

Originally posted by : TheDude (TheDude@bananateam.nl)hi, if you manage to create a stored procedure in access, let me know, cause as far as I know, it's not possible..but to answere your question, try the field type"memo"regards The Dude------------Drew at 12/7/2001 7:25:50 PMI want to create a stored procedure to inesrt text into a field of my MS Access 2000 database. I created the field as Memo type in access since that is supposed to be able to contain up to 65000 characters. In my stored procedure, however, i don't know what datatype to make the paramater that I am going to to insert into that field. I tried Text, and it threw an error if i tried over 256 characters. I also tried varchar(20000), and that allowed me to enter somewhere around 800 characters without throwing an error. What is the correct data type to use to support 10000 or so characters? thankS!

Originally posted by : Mike Hingley (mike.hingley@aquila-networks.co.uk)Why a Stored procedure? Could DTS do it beter? DTS orffers the ability to apply Data transformations to a plethora of datasources, wuthout even using SQL.Therefore it is possible to create a DTS package insert of move of even copy data between one data source and access. The Manual gives some good examples of this.In terms of memo - THis data type is not supported directly - However I believe that it is a TEXT (16) FIELD - Try getting a copy of the Access upsize wizard, which allows you to upload an Access DB to SQL Server.In terms of passing data to Access, then ther are many ways of doing this - However if you are going to use the SP approach, then TEXT seems to be the best way to ensure that the data is big enough.Question - Do you really need the memo? Can you use a better structure? The Memo is really inefficient? Perhaps a better storage type would be to allow multiple text fields to be stored against a parent record (Foreign key solution?)Mike Hingley - MCP------------TheDude at 1/7/2002 1:40:10 PMhi, if you manage to create a stored procedure in access, let me know, cause as far as I know, it's not possible..but to answere your question, try the field type"memo"regards The Dude------------Drew at 12/7/2001 7:25:50 PMI want to create a stored procedure to inesrt text into a field of my MS Access 2000 database. I created the field as Memo type in access since that is supposed to be able to contain up to 65000 characters. In my stored procedure, however, i don't know what datatype to make the paramater that I am going to to insert into that field. I tried Text, and it threw an error if i tried over 256 characters. I also tried varchar(20000), and that allowed me to enter somewhere around 800 characters without throwing an error. What is the correct data type to use to support 10000 or so characters? thankS!